Defining a new short number format

If the values on an axis or a column are numerical, you can choose to display them in short number format. This means that values with many digits can be shortened to take up less space. For example, by using short number format you can set the number 1,000 to be shown as 1k. A standard symbol set is already defined and available to use. The defined symbols in the standard symbol set are M for 10^6, and k for 10^3. You cannot delete or change the standard symbol set. However, you can add your own symbol sets and define symbols of your choice in the installed client.

Before you begin

New short number formats must be added using the installed client.

As with other formatting settings, you can apply short number formatting in different ways and on different levels. See Changing the formatting of a column for more information. For specific details about formatting settings, see Formatting details.

Procedure

In the installed client, open Tools > Options and go to the Axis formatting page.
Click Edit Symbol Sets.
Click Add in the upper part of the dialog.
Type a name to use for the new symbol set in the text field and click OK.
The symbol set is added to the drop-down list.
Click Add next to the Defined symbols list to add symbols to the symbol set.
You should all abbreviations that should be available to the values in a column to your new symbol set. For example, you could add k, M, G, T, if you expect to have a wide range of large numbers in a column.
Enter an exponent and a symbol to replace it with and click OK. Repeat for the next symbol.
Click OK to close all dialogs.

Results

The new symbol set is added to the list of defined symbols under Use short number format in the Formatting settings dialogs.