Open the Data Labels group of parametersData labels contain information on series or specific data points and make the chart easier to understand. Labels are added to all chart series. Depending on the information to be selected in the chart, the user can add data labels for:
All chart series.
A single series.
Setting up data labels is available for all visualizer types, except tables, scatter charts , Sankey charts, and indicators.
To set up data labels, use the Data Labels group of parameters on the side panel.
Open the Data Labels group of parameters
To open the Data Labels group of parameters:
Select a chart.
Press the 
Settings button on the toolbar. The side panel is hidden by default.
Select the required group of parameters.
To show data labels, select the Data Labels checkbox and determine the settings:
Conditional formatting setup for data labels is available in column charts and bar charts.
After conditional formatting rules are set, label color setup becomes unavailable.
To set up the formatting that is applied only when a specific condition is executed:
Click the Add Rule button. The Formatting Rule panel opens:
Select the data label formatting rule in the drop-down list:
The settings are identical to the settings determined for the conditional formatting applied to table cells.
Conditional formatting of data labels is calculated based on the source values from the data source regardless of which values are displayed in the label template.
To edit the formatting rule, double-click the formatting rule title in the Conditional Formatting group of parameters on the side panel. The Formatting Rule panel opens:
To reorder formatting rules:
Hover the cursor on the formatting rule.
Hold down the mouse button and move the rule to the required position.
To delete the formatting rule:
Hover the cursor on the formatting rule.
Click the Delete button.
After confirming the operation the selected formatting rule is deleted.
Determine font settings:
Font. Select one of the available fonts in the drop-down list. If required, one can load custom fonts.
Font Size. Select the required font size. Size is set in points, it can be selected in the drop-down list or entered using the keyboard. The range of available values: [8; 36].
Color. Select font color in the drop-down palette.
Font color setup is unavailable if conditional formatting settings are determined.
One can select standard and custom colors. The palette contains only standard colors by default.
To create a custom color:
Click the Add Color button. The advanced color palette opens.
Select a color in the advanced color palette, use color picker to select color on a browser page, or set color code in the RGB or HEX format.
After executing the operations the custom color is created and added to the palette.
NOTE. The maximum possible number of custom colors in the palette is 23.
To delete the custom color from the palette, select the Delete item in the selected color's context menu.
Font style. Select font style:
B. Bold.
I. Italic.
U. Underline.
When the button is pressed, the corresponding font style is used. Several styles can be used simultaneously, for example, pressed B and I buttons result in bold italic font style.
To reset the settings and restore the default style, click the 
Delete button.
A custom text, template can be set for the label, or combination of both. To enter text and templates, use the Text box.
To add a template to the label text:
Click the Add Template button.
In the drop-down list select one of the available text templates.
After executing the operations the selected template will be added to label text after the cursor.
Available templates:
%PointNo. Point number.
%PointName. Point name.
%SerieNo. Series number.
%SerieName. Series name.
%Data. Custom data format. Format setup is available only using the Fore language.
%PercentPartHundredth. Cumulative shares.
%PercentPart. Percentage cumulative shares.
%PercentHundredth. Shares are the ratio of the series point value to the sum of values of this point over all the series.
%Percent. Percent shares are ratio of the series point value to sum of values for this point in all series, shown as a percentage.
%Part. Cumulative value.
%YValue. Y axis point value.
%XValue. X axis point value.
%Value. Point value.
%Autovalue. Default value. Automatic value format. Data series point value will be used for all charts, except pie charts. Pie charts use the ratio of the series point value to the sum of values of this point over all the series.
There are the following data label position options for charts:
Automatically. Default value. Data label position is selected automatically.
Center.
Inside end.
Outside end.
Inside base.
Custom.
NOTE. The Left, Top, Right, Bottom options are available for line charts, radar charts, and area charts. The Inside End, Outside End, and Inside Base options are unavailable. The Automatically and Custom options are available for mixed charts.
When a custom label position is selected, the following becomes available:
Horizontal label position. In the drop-down list select horizontal label position option: right, center, left. The center position is selected by default.
Vertical label position. In the drop-down list select vertical label position option: bottom, center, top. The center position is selected by default.
Offset. Set label offset length relative to a series horizontally, vertically and label offset percentage relative to column length.
There following data label position options are available for charts:
Simple. The label is displayed as a mark not connected to the series (default).
Callout. The label is displayed as a callout connected to the series with a line.
Pointer. The label is displayed as a pointer connected to the series with a line.
In column charts, bar charts, pie charts, and doughnut charts, for the Outside End data label position option, and for any data label position for the label types the Hide Labels on Intersection checkbox is available.
Pie chart examples when the Hide Labels on Intersection checkbox is deselected and selected:
When a new data label positioning mechanism is used, data labels are not intersected.
To change data format settings, select one of the supported data formats in the drop-down list. The different settings are available depending on the selected format:
General. Equal to canceling formatting.
Number. When the Number format is selected, the following settings are available:
Decimal Places. Select the number of displayed decimal places.
Negative Numbers. Select the format of displaying negative numbers.
Thousands Separator. Select the checkbox to apply the thousands separator option. The checkbox is deselected by default.
Percentage. When the Percentage format is selected, the Decimal Places setting is available. Select the number of displayed decimal places.
When the Percentage format is used, number values are multiplied by 100 and the "%" character is added. Values entered into a cell are processed in different ways depending on the way the % character is used. For example, when 40% is entered, the cell displays 40%, but the cell value is 0.4. When 40 is entered, the cell displays 4000%, but the cell value is 40.
Currency. When the Currency format is selected, the following settings are available:
Decimal Places. It sets the number of displayed decimal places.
Symbol. It sets currency symbol.
Negative Numbers. Select the format of displaying negative numbers.
Date. When the Date format is selected, the Type setting is available. Select date display format in the drop-down list.
Time. When the Time format is selected, the Type setting is available. Select time display format in the drop-down list.
Exponential. This format is used to show a number in exponential format. When the Exponential format is selected, the Decimal Places setting is available. Select the number of displayed decimal places.
Text. Equal to canceling formatting.
Additional. When the Additional format is selected, the Type setting is available. To automatically convert value, select the preset option:
Zip code.
Telephone number.
Table number.
Custom. It contains code views of all available data formats. When the Custom format is selected, the Type setting is available. To automatically convert value, select the preset option.
Examples of number templates:
Format |
Initial value |
Displayed value |
| # | 5 | 5 |
| 00 | 5 | 05 |
| #,# | 10 1000 |
10 1 000 |
| #.0# | 12 12,557 |
12,0 12,56 |
| #,#.000 | 150 | 150,000 |
| #, | 10000 | 10 |
| #,.00 | 100 | 0,10 |
| #.0E+00 | 1000 | 1,0E+003 |
To reset the settings and restore the default style, click the Delete button.
The number of displayed settings depends on the chart type.
The Data Labels checkbox is deselected by default, and data labels are not displayed.
See also: