Data Labels: Regular report

Data labels contain information about data series or single data points and make it easier to understand a chart. Labels are added to all chart series. Depending on what should be selected in a chart, labels can be added to:

To set up data labels, use the Data Labels group of parameters on the side panel.

To open the Data Labels group of parameters, select the chart and click the Parameters button on the toolbar, then select the required group.

To show data labels, select the Data Labels checkbox and determine the settings:

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. 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 a palette is 23.

To delete 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 font options, 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 can be set up using the Fore language.
%PercentPartHundredth. Cumulative shares.
%PercentPart. Percentage cumulative shares.
%PercentHundredth. Shares are ratio of the series point value to sum of values for this point in all 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. Point value along the Y axis.
%XValue. Point value along the X axis.
%Value. Point value.
%Autovalue. Default value. Automatic value format. Series point value will be used for all charts except the pie charts. The ratio of a series point and a sum of values of the same point of all series is used for pie charts, secondary pit charts and secondary histogram.

There are the following data label position options for charts:

Automatically.
Center.
Inside End.
Outside End.
Inside Base.
Custom.

NOTE. The Left, Top, Right, and Bottom options are available for line charts, scatter charts, bubble charts, stepped charts, radar charts, area charts. The Inside End, Outside End, and Inside Base options are not available.

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 option is selected by default.

Vertical label position. In the drop-down list select vertical label position option:

Bottom.
Center.
Top.

The Center option is selected by default.

Label offset. Set label offset length relative to a series horizontally, vertically and label offset percentage relative to column length.

The setting is available for all chart types, except bubble charts.

The 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.

The Hide Labels on Intersection checkbox is available for pie charts and doughnut charts if the Outside End data label position option is used for the Callout and Pointer label types.

Pie chart appearance if the Hide Labels on Intersection checkbox is deselected:

Pie chart appearance if the Hide Labels on Intersection checkbox is selected:

As a result, a new data label positioning mechanism is used, which prevents their intersection.

To change data format settings, select one of the supported data formats in the drop-down list. Depending on the selected format, different settings are available:

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 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. The numbers entered into a cell in this format are processed in a different way depending on the use of the % character. 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 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	Source 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 special format settings, click the Delete button.