Adding Billions to Default Scaling

qSIChartView, by default, has 1000,1000 (K,M) scaling defined for all charts. It does not have the scaling for billions defined. You can modify the number scaling to add billion so that the final scale looks like 1000,1000,1000 (K,M,B).

This scale would look something like:

•	1000 = 1 K

•	1000 K = 1 M

•	1000 M = 1 B

To convert this scale into qSIChartView format

1	From Chart Attributes, click Edit.

2	Click Number Formatting.

3	In the Number Scale Value box, enter 1000,1000,1000.

4	In the Number Scale Unit box, enter K,M,B.

5	Click Save.

Whatever numeric figure was present on the left hand side of the table is put in Number Scale Value and whatever unit was present on the right side of the scale table has been put under Number Scale Unit - all separated by commas.

If you want to set the chart formatting flags

1	From Chart Attributes, click Edit.

2	Click Number Formatting.

3	From Format Number, select True.

4	From Format Number Scale, select True.

5	In the Number Prefix box, enter $.

6	Click Save.

When you now view a chart containing data in billions, you will see the following chart. Note that the chart now contains figure both in millions and billions.

Figure 27. Setting chart formatting