Page tree

Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Comment: Migration of unmigrated content due to installation of a new plugin

...

Description

Excerpt

Sets or returns the formula specifying the positive error value.

Signature
C#
C#
 public System.String CustomPlusFormula{ get; set; }
{signature}{signature:
}
Signature
vb.net
vb.net
Public Property CustomPlusFormula() As String
{signature}
{remarks}
This formula should reference a range of cells that contains the values for the positive error. If there is only one cell referenced, then all data points will have a positive error equal to the value in that cell. If there are multiple cells referenced 
Remarks

This formula should reference a range of cells that contains the values for the positive error. If there is only one cell referenced, then all data points will have a positive error equal to the value in that cell. If there are multiple cells referenced (e.g.

A1:A5),

then

the

first

cell's

value

will

be

used

for

the

positive

error

of

the

first

data

point,

the

second

cell's

value

will

be

used

for

the

second

data

point,

and

so

on.

The

positive

error

value

represents

the

error

in

the

positive

direction.

For

example,

if

you

have

a

data

point

at

a

Y

position

of

3.0,

and

the

positive

error

value

for

the

[

ErroyBarY

|Series.ErrorBarY]

is

.5,

then

the

error

bar

will

extend

from

3.0

(the

data

point)

to

3.5

(the

error

value

added

to

the

data

point).

The

[

CustomMinusFormula

|ErrorBar.CustomMinusFormula]

specifies

the

error

going

in

the

other

direction.

Setting

this

property

will

cause

the

error

bar

to

show

its

positive

error

if

it

was

not

already

doing

so,

and

will

change

the

[

ValueType

|ErrorBar.ValueType]

property

to

Custom.

By

default

error

bars

will

use

a

FixedValue

[

ValueType

|ErrorBar.ValueType]

,

and

CustomPlusFormula

will

return

an

empty

string.

{remarks}