Graphs
VisibleGuidelinesXAxis (YAxis)EnabledIf activated the |
guideline is visible. |
Function
The function. The function must be in math.js Syntax. With variable x.
Color
The color in which the function should be drawn.
Width
The width of the function in pixels.
Trendline
Conditional Formatting 0 - 9
VisibleLabelCreates a label at the given position. If the label is "auto" the label is the value of the axis it is displayed on, if the label is "none" no label is displayed, every other text will be displayed as a label. ValueSets the position of the guideline. If the value is "mean" the average value of the axis is used. WidthSets the width of the guideline. ColorSets the color of the guideline. Bold LabelIf activated the label is bold. | |
HighlightRangesXAxis (YAxis)EnableIf activated the hIghlight range will be visible. Start ValueThe start of the hightlight range. Instead of a number you can use min, mean and max. End ValueThe end of the hightlight range. Instead of a number you can use min, mean and max. OpacitySets the transparency of the highlight range from 0 (invisible) to 1 (no transparency) ColorSets the color of the highlight range. | |
TrendlineEnableIf activated the trendline will be visible. ColorThe color of the trendline. WidthThe width of the trendline in pixels. Show Correlation CoefficientActivates the display of the correlation coefficient under the legend of the Bubbles. This indicates exactly how the trend of the trend line can be determined. The value varies between 1 (absolutely accurate trend line) and 0 (trend line not meaningful). |
X- / Y-Axis Highlight Range
Start
The start of the hightlight range. Instead of a number you can use min, mean and max.
End
The end of the hightlight range. Instead of a number you can use min, mean and max.
Opacity
Sets the transparency of the highlight range from 0 (invisible) to 1 (no transparency)
Color
Sets the color of the highlight range.
GraphFunctionsEnableIf activated the function will be visible. Math.js FunctionThe function in math.js Syntax. With variable x. ColorThe color in which the function-graph should be drawn. WidthThe width of the function-graph in pixels. | |
ConditionalFormattingEnableActivates or deactivates the formatting. Source SeriesSets the datasource for the operands.
OperatorThe operation of the condition. |
|
|
|
|
|
|
|
|
contains: Does the value contain the first value? (for label)
Value 1 / 2
The value to compare toIf activated the labels gets drawn bold.First / Second ValueThe values the operator uses. EffectThe effect if the condition is true.
Effect ValueThe value of the effect. |
x- / y-Guidelines
Visible
If activated the guideline is visible.
Label
Creates a line and a label at the given position. If the label is "auto" the label ist the value the axes it is displayed on, if the label is "none" no label is displayed, every other text will be displayed as a label.
Value
Sets the position of the guideline. If the value is "mean" the average value of the axis is used.
Width
Sets the width of the guideline.
Stroke
Sets the color of the guideline.
LabelBold
BubblesToBeHighlightedSelector StringThe selector detemerines which bubbles should be displayed. |