...
Value Format
With the Value Format you define the way values are displayed in the diagram.
Use Pre-Formatted Data
If this option is activated, the number formatting of the data source is used.
Value Format basic
Select the format of the absolute and percentage values according to guidelines of numeral.js. locale sets the label country format in the Basic mode. DE, FR, EN and AUTO are available options. Choosing AUTO the Locale is retrieved from the Data Source.
Value Format extended
If a fixed format is preferred, put the format for absolute and percentage values here. Choosing a “(“ in the box Negative Sign will show negative values in brackets: (1234). The parameter in the box Scaling is used as a divisor for scaling the data label. The resulting format string can also be set via scripting language – for further details see the Number Formatting.
NULL Value Replacement
If set, all NULL values are displayed as this string.
Infinity Replacement
If set, all Infinity values are displayed as this string.
Zero Replacement
If set, all 0 values are displayed as this string.
Suppress Zero Labels
Hiding Category Labels in case of zero values.
Value Format universal
You can access the configuration by clicking on an element in the list.
Define the number format using the following options:
- Locale: Defines abbreviations, decimal and thousand separators for the respective language. You can choose between en, de, fr and auto.
- Format Type: Defines the type of number output. You can choose between number (decimal number), percent (percentage) and ordinal (ordinal number).
- Abbreviations: Defines the type of abbreviations for all numbers to be formatted. You can choose between mean (abbreviation of the mean value), min (abbreviation of the minimum value), max (abbreviation of the maximum value), auto (best-suited abbreviation for the respective number), trillion (trillion abbreviation), billion (billion abbreviation), million, thousand and none (no abbreviation at all).
- Negative Sign: Defines how negative numbers are displayed. You can choose between minus, parenthesis, and none (no sign).
- Prefix: The input value is placed before the number.
- Suffix: The input value is placed after the number.
- Thousands Separator: Replaces the thousand separator set by the selected locale.
- Decimal Separator: Replaces the decimal separator set by the selected locale.
- Total Digits: Defines how many digits the number may consist of. Total Digits is prioritized over Decimal Digits.
- Decimal Digits: Defines how many decimal places of the formatted number are displayed.
- Scaling Factor: The value of each data point is multiplied by the entered number to scale values.
- Zero Format: When the checkbox is activated, any data value equal to 0 (the number zero) is replaced by the entered value.
- Null Format: Any data value that equals NULL (no value) is replaced by the entered value.
- Error Format: If a data value is undefined or the result of an arithmetic error such as dividing by 0 (zero), the data value is replaced by the entered value.
- Rounding Method: Defines the rounding method. You can choose between half up (23.5 → 24, -23.5 → -23), commercial (23.5 → 24, -23.5 → -24) and trim (23.5 → 23, -23.5 → -23).
- Explicit Positive Sign: Defines whether a positive number should always be preceded by a + (plus sign).
- Description: Defines a description for the set configuration.
...
...
Value Labels
Label Positioning
Determine the mode that controls the data labeling. Three modes are available:
- none: The data label is not displayed.
- fix: The data label is always displayed.
- auto: In case of overlaps, the data label is hidden or offset; adjustable by means of Collision Adjustment
Collision Adjustment [px]
Adjusts the collision algorithm of the labels of the auto mode of the value labels. The smaller the value, the more sensitive the algorithm is to collisions. Negative values are also allowed. (Note: Bold labels are not considered by the collision algorithm, so they always appear).
Background
This option draws a colored area behind the Value Labels. With Background Color you define the desired color.
Background Color
With Background Color you define the desired color of the area.
Visible Element Labels
Specify whether or not the element labelling should be displayed for a series.
...
Image Removed
...
Label Picking
If this option is enabled, you can use the subordinate settings to control which labels are displayed according to certain criteria. Consequently, only those labels that match the selected criteria are displayed. The following options are available:
Force First Value Label
The first label of a series is displayed.
Force Last Value Label
The last label of a series is displayed.
Force Min Value Label
The minimum value of each series is displayed.
Force Max Value Label
The maximum value of each series is displayed.
Force Before Separators
All values before a separator are displayed. This option depends on the settings under Separators.
Force Peak Labels
This option displays local minima and maxima. What a local minimum/maximum is can be controlled with the option Minimum Peak Size in %.
Minimum Peak Size in %
Determines how much values must deviate from their neighbors to be considered a local minimum/maximum.
Check Only Leading Values For Peak
The peak calculation only refers to the previous value; the following value is not taken into account.
...
Image Removed
...
Font
Size [px]
This property determines the font size in pixel.
Family
Define the global font. You can choose between Arial, Tahoma, Lucida Console, Verdana and Calibri or type in the name of a font which is installed on your system.
Color
This property determines the font color as HEX code. Alternatively, the Color Picker can be used.
...
Title
Title Text
...
Excerpt |
---|
With the Value Format you define the way values are displayed in the diagram. If this option is activated, the number formatting of the data source is used. Select the format of the absolute and percentage values according to guidelines of numeral.js. locale sets the label country format in the Basic mode. DE, FR, EN and AUTO are available options. Choosing AUTO the Locale is retrieved from the Data Source. Value Format extendedIf a fixed format is preferred, put the format for absolute and percentage values here. Choosing a “(“ in the box Negative Sign will show negative values in brackets: (1234). The parameter in the box Scaling is used as a divisor for scaling the data label. The resulting format string can also be set via scripting language – for further details see the Number Formatting. NULL Value ReplacementIf set, all NULL values are displayed as this string. Infinity ReplacementIf set, all Infinity values are displayed as this string. Zero ReplacementIf set, all 0 values are displayed as this string. Suppress Zero LabelsHiding Category Labels in case of zero values. You can access the configuration by clicking on an element in the list. Define the number format using the following options: - Locale: Defines abbreviations, decimal and thousand separators for the respective language. You can choose between en, de, fr and auto.
- Format Type: Defines the type of number output. You can choose between number (decimal number), percent (percentage), ordinal (ordinal number) and Time (time unit).
- Abbreviations: Defines the type of abbreviations for all numbers to be formatted. You can choose between mean (abbreviation of the mean value), min (abbreviation of the minimum value), max (abbreviation of the maximum value), auto (best-suited abbreviation for the respective number), trillion (trillion abbreviation), billion (billion abbreviation), million, thousand and none (no abbreviation at all).
- Negative Sign: Defines how negative numbers are displayed. You can choose between minus, parenthesis, and none (no sign).
- Prefix: The input value is placed before the number.
- Suffix: The input value is placed after the number.
- Thousands Separator: Replaces the thousand separator set by the selected locale.
- Decimal Separator: Replaces the decimal separator set by the selected locale.
- Total Digits: Defines how many digits the number may consist of. Total Digits is prioritized over Decimal Digits.
- Decimal Digits: Defines how many decimal places of the formatted number are displayed.
- Scaling Factor: The value of each data point is multiplied by the entered number to scale values.
- Zero Format: When the checkbox is activated, any data value equal to 0 (the number zero) is replaced by the entered value.
- Null Format: Any data value that equals NULL (no value) is replaced by the entered value.
- Error Format: If a data value is undefined or the result of an arithmetic error such as dividing by 0 (zero), the data value is replaced by the entered value.
- Rounding Method: Defines the rounding method. You can choose between half up (23.5 → 24, -23.5 → -23), commercial (23.5 → 24, -23.5 → -24) and trim (23.5 → 23, -23.5 → -23).
- Explicit Positive Sign: Defines whether a positive number should always be preceded by a + (plus sign).
- Time Units: If Time has been specified for the format type, the time units can be set here. The default setting interprets data values as seconds and displays them as hours and minutes with decimal places in the format h:mm.m
- Description: Defines a description for the set configuration.
For the Format Type Time, a system of units can be configured with the help of the Time Units Property, which in the default setting consists of hours and minutes. Each number formatted in this way is then splitted in its values for each unit. The order of the unit list defines their relationship from the largest unit (top) to the smallest unit (bottom). Each unit contains the following options: - Modulus: defines the arithmetic relationship between the units. In terms of modular arithmetic, the number reflects how many entities of the next smaller unit fit into an entity of the current unit. If the current unit is the smallest of the unit system, the modulus establishes the reference to the raw value to be formatted. Thus, in the case of a unit system of hours and minutes with raw values that are given in minutes, the hours unit carries the modulus 60 and the minutes unit carries the modulus 1.
- Prefix: Defines the local prefix with which the value of this unit should begin. It can be used as a separator to values of larger units.
- Suffix: Defines the local suffix that should follow the value of this unit. For example, it can contain a unit abbreviation or be used as a separator to values of smaller units.
- Omit If Zero: Sets whether values of this unit should be omitted if they equal 0.
- Leading Zeros: Sets whether values of this unit should be displayed with one or more leading zeros (depending on the reference to the next larger unit).
- Description: Sets a description for the unit to make it easier to recognize in the list.
| | Value LabelsLabel PositioningDetermine the mode that controls the data labeling. Three modes are available: - none: The data label is not displayed.
- fix: The data label is always displayed.
- auto: In case of overlaps, the data label is hidden or offset; adjustable by means of Collision Adjustment
Collision Adjustment [px]Adjusts the collision algorithm of the labels of the auto mode of the value labels. The smaller the value, the more sensitive the algorithm is to collisions. Negative values are also allowed. (Note: Bold labels are not considered by the collision algorithm, so they always appear). BackgroundThis option draws a colored area behind the Value Labels. With Background Color you define the desired color. Background ColorWith Background Color you define the desired color of the area. Visible Element LabelsSpecify whether or not the element labelling should be displayed for a series. | Image Added | Label PickingIf this option is enabled, you can use the subordinate settings to control which labels are displayed according to certain criteria. Consequently, only those labels that match the selected criteria are displayed. The following options are available: Force First Value LabelThe first label of a series is displayed. Force Last Value LabelThe last label of a series is displayed. Force Min Value LabelThe minimum value of each series is displayed. Force Max Value LabelThe maximum value of each series is displayed. Force Before SeparatorsAll values before a separator are displayed. This option depends on the settings under Separators. Force Peak LabelsThis option displays local minima and maxima. What a local minimum/maximum is can be controlled with the option Minimum Peak Size in %. Minimum Peak Size in %Determines how much values must deviate from their neighbors to be considered a local minimum/maximum. Check Only Leading Values For PeakThe peak calculation only refers to the previous value; the following value is not taken into account. | Image Added | FontSize [px]This property determines the font size in pixel. FamilyDefine the global font. You can choose between Arial, Tahoma, Lucida Console, Verdana and Calibri or type in the name of a font which is installed on your system. ColorThis property determines the font color as HEX code. Alternatively, the Color Picker can be used. | Image Added | TitleIf the Enable checkbox is activated, the title will be displayed. Title TextEnter a Title for the charts here. Multiline texts will be rendered accordingly, i.e. the line break will be applied. The following HTML tags can be used for formatting: 'b', 'i', 'p', 'span', 'div', 'br', 'h1', 'h2', 'h3', 'h4', 'h5', 'h6', 'hr', 'ol', 'ul', 'li' and 'blockquote'. For the following result ACME Ltd. P&L by Segment 2021 AC, BU this input is necessary: ACME Ltd. <b>P&L</b> by <i>Segment</i> 2021 AC, BU | | Series LabelsLeft/TopActivate the checkboxes to display the data label on the left/top of the data series. Right/BottomActivate the checkboxes to display the data label on the right/bottom of the data series. Series LabelEnter the desired labeling of a series manually. Max Series Labels Width [px]Maximum width of the data series labels, up to where the padding is scaled. If this value is exceeded, the labels are cut off. | | Category LabelsEnableIf the check mark is set, category labels are displayed on the diagram. VisibilitySet line by line (level x) whether the category label should be displayed or not. Max Width [px]If this value is greater than 0, it indicates the reserved space for the category labels in pixels. If the length of the labels is greater than the specified width, they are shortened by omission points. For values smaller or equal to zero, the reserved space is calculated automatically. Max Category Label Width can only be set in Structure Mode and with deactivated hierarchical labels (Hierarchical Label Display set to false). Suppress RepetitionControls line by line (level x) whether repetitive category labels should be suppressed or displayed. Hierarchical Label DisplayEnables a hierarchical display of category labels. The category labels of each member are displayed in a separate column. The hierarchical display is only possible in Structure Mode. Line Break Category LabelsThe character or string in place of which category labels are split across multiple lines. For example, using a space for the label "ACT Jan 2001" would make it a three-line label. Category Label Rotation [degree]Specifies the angle by which the category labels are rotated. The rotation is counterclockwise. Crop Category LabelsIf this option is enabled, the category labels in Time mode will have a maximum width of the specified category width. If the labels are longer, they will be truncated by ... cut off. Selected Members in CategoriesSpecifies whether the members of selected measures should be displayed as a supplement in the category labels. Selected Measures in CategoriesSpecifies whether the selected measures should be displayed as a supplement in the category labels. | Image RemovedImage Added | Axis LabelsLeft/TopActivate the check boxes to display the axis label on the left/top of the data series. Right/BottomActivate the check boxes to display the axis labeling on the right/bottom of the data series. Axis LabelsEnter the desired labeling of the axis manually. Line Break Axis LabelsThe character or string where the axis labels are split over several lines (similar to the property line break category labels).
| | If this check mark is set, tooltips are displayed on the diagram at runtime, showing detailed information for the corresponding element. Select the the format of the absolute and percentage values according to guidelines of numeral.js. locale sets sets the label country format in the Basic mode. DE, FR, EN and AUTO are available options. Choosing Choosing AUTO the the Locale is retrieved from the Data Source. Value Format extendedIf a fixed format is preferred, put the format for absolute and percentage values here. Choosing Choosing a “(“ in the box Negative Sign will show negative values in brackets: (1234). The The parameter in the box Scaling is used as a divisor for scaling the data label. The The resulting format string can also be set via scripting language – for further details see the the Number Formatting. You can access the configuration by clicking on an element in the list. Define the number format using the following options: - Locale: Defines abbreviations, decimal and thousand separators for the respective language. You can choose between en, de, fr and auto.
- Format Type: Defines the type of number output. You can choose between number (decimal number), percent (percentage) and ordinal (ordinal number).
- Abbreviations: Defines the type of abbreviations for all numbers to be formatted. You can choose between mean (abbreviation of the mean value), min (abbreviation of the minimum value), max (abbreviation of the maximum value), auto (best-suited abbreviation for the respective number), trillion (trillion abbreviation), billion (billion abbreviation), million, thousand and none (no abbreviation at all).
- Negative Sign: Defines how negative numbers are displayed. You can choose between minus, parenthesis, and none (no sign).
- Prefix: The input value is placed before the number.
- Suffix: The input value is placed after the number.
- Thousands Separator: Replaces the thousand separator set by the selected locale.
- Decimal Separator: Replaces the decimal separator set by the selected locale.
- Total Digits: Defines how many digits the number may consist of. Total Digits is prioritized over Decimal Digits.
- Decimal Digits: Defines how many decimal places of the formatted number are displayed.
- Scaling Factor: The value of each data point is multiplied by the entered number to scale values.
- Zero Format: When the checkbox is activated, any data value equal to 0 (the number zero) is replaced by the entered value.
- Null Format: Any data value that equals NULL (no value) is replaced by the entered value.
- Error Format: If a data value is undefined or the result of an arithmetic error such as dividing by 0 (zero), the data value is replaced by the entered value.
- Rounding Method: Defines the rounding method. You can choose between half up (23.5 → 24, -23.5 → -23), commercial (23.5 → 24, -23.5 → -24) and trim (23.5 → 23, -23.5 → -23).
- Explicit Positive Sign: Defines whether a positive number should always be preceded by a + (plus sign).
- Description: Defines a description for the set configuration.
| |
|