Data Labels

To open the Data Labels group of parameters:

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:

1. Click the Add Color button. The advanced color palette opens.

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

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

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:

1. Click the Add Template button.

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

• %PercentPartHundredth. Cumulative shares.

• %PercentPart. Percentage cumulative shares.

• %PercentHundredth. Shares are the ratio of the 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 value.

• %XValue. X axis value.

• %Autovalue. Default value. Automatic value format. Data series point value will be used for all charts, except for 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. Default value.

• Left.

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

• Bottom.

• Center. Default value.

• Top.

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