Skip to end of metadata
Go to start of metadata

For most chart types, the number format can be specified. It determines how numbers are presented in the chart. Every chart with a number format has settings for:

  • Displaying the number of decimals
  • Whether or not showing a display unit along the axes, and which display unit
  • Whether or not using a thousands separator


Depending on the type of chart these settings can be defined for one or two axes.

In addition, it is possible to define the number format for the axis of the line chart. Which details can be set, depends on the chosen type of values that must be presented on the axis.

There is also a column number format, which can be set separately for table chart columns.

Specifying the number format for a chart

  1. Select the chart, and click  to open the chart's Settings window.

  2. On the Representation tab, set one or more of the following settings. The availability of a setting depends on the chart type.

    Decimal places: Enter the number of decimals that must be shown in the values on the chart axis. You can set up to three decimal places.

    Decimal places x-axis: Enter the number of decimals that must be shown in the values on the x-axis of the chart. You can set up to three decimal places.

    Decimal places y-axis: Enter the number of decimals that must be shown in the values on the y-axis of the chart. You can set up to three decimal places. For a line chart the Type of x-axis must be set to Real for this setting to be effective.

    Display unit: Select the display unit that must be shown along the chart axis. Select none if you do not want to show a display unit.

    Display unit x-axis: Select the display unit that must be shown along the x-axis of the chart. Select none if you do not want to show a display unit. For a line chart the Type of x-axis must be set to Real for this setting to be effective.

    Display unit y-axis: Select the display unit that must be shown along the y-axis of the chart. Select none if you do not want to show a display unit.

    Use 1000 separator: Activate this setting if a thousands separator must be shown in the values along the chart axis.

    Use 1000 separator x-axis: Activate this setting if a thousands separator must be shown in the values along the x-axis of the chart. For a line chart the Type of x-axis must be set to Real for this setting to be effective.

    Use 1000 separator y-axis: Activate this setting if a thousands separator must be shown in the values along the y-axis of the chart.

  3. Close the Settings window.


Related articles