Show TOC

 Adding Data LabelsLocate this document in the navigation structure

Use

You can display data labels in a chart as required and use them, for example, to display the absolute value for all data points.

You can add data labels for the following:

  • All data series
  • A single data series
  • A single data point
Procedure

Adding data labels to a single data series

  1. Select the property Series → Series 1 → Show Labels, whereby Series 1 stands for the series for which you want to add the label.
  2. Enter the content to be displayed on the label into the Format field. There are many possibilities that you can implement here using simple syntax.

The formal syntax for the data label is {free text}{indicator} {0} [,|.]{0} {free text}, whereby the first position specifies which value is specified, absolute or numeric percentage value or name of the field, the second position defines the number format, and the last position allows free text input for specifying the unit.

Label type {indicator}

$Label:Uses the text from the property Data Series  → Data Series 1 → Label.

$Abs:Uses the absolute value of the data point.

$Percent:Uses the percentage share of the data point.

Number format

You enter the number format using zero and thousand separators or decimal points as required. Note the following:

  • Country-specific settings can influence the number format that is displayed.
  • You can override the country-specific settings by using the separator $Sep.

Decimal places

0.00: The value is displayed to 2 decimal places.

If a value is 200 and the country setting is Germany, the format that is displayed is 200,00.

If a value is 200 and the country setting is England, the format that is displayed is 200.00.

The country-specific settings are not valid for the following syntax:

If a value is 200 and the syntax is $Sep10.00,the result is 200.00.

If a value is 200 and the syntax is $Sep20.00,the result is 200,00.

0.   The value is displayed without decimal places.

Thousand separators

0,   The value is displayed with thousand separators.

If a value is 2000 and the country setting is Germany, the format that is displayed is 2.000,00.

If a value is 2000 and the country setting is England, the format that is displayed is 2,000.00.

The country-specific settings are not valid for the following syntax:

If a value is 2000 and the syntax is $Sep10.00,the result is 2,000.00.

If a value is 2000 and the syntax is $Sep20.00,the result is 2.000,00.

Free text

You can enter free text before or after the value. Place the free text in inverted commas. Also, place a space in the inverted commas in order to create space between the free text and other text.

Tip

$Abs$Sep20,00" EUR" gives the label 1234.5689 EURfor a value of 1,234.56 EUR.

"The percentage share is "$Percent0." %"gives the label The percentage share is 25 %.