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
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.
The exponent defines the power of 10 you want to replace with a
symbol when using the short number formats. To replace 10^3 (1,000) with the
symbol k, enter 3 in the field. The number 1,000 will then be displayed as 1k,
and the number 1,250 will be displayed as 1.25k. You cannot use any numerical
values as symbols.
-
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.