PowerCharts XT offers a lot of options to format numbers on the chart. You can configure number prefixes & suffixes, decimal places, and scaling of numbers based on a pre-defined scale. In this section, we'll see the number formatting properties supported by PowerCharts XT and look into number scaling in the next section.

We will start with setting decimal precisions for the numbers on chart.

All the charts in PowerCharts XT supports the attribute decimals. This single attribute lets you control the decimal precision of all the numbers on the chart. Using this attribute, you can globally set the number of decimal places of all numbers of the chart.

For example, if you have numbers on your chart as 12.432, 13.4 and 13 and you set <chart ... decimals='2' >, the numbers would be converted to 12.43, 13.4 and 13 respectively.

Similarly, if you had data as 0.12342, 0.134 and 0.13, and you set decimals as 3, PowerCharts XT would output 0.124, 0.134 and 0.13 respectively. Note that even though we have set decimals to 3, PowerCharts XT now does not forcibly add the 0 padding to 0.13 to form 0.130, as the trailing 0 is unnecessary.

However, if you want your numbers on the chart to have trailing zeroes too, you can set <chart ... forceDecimals='1' > and now the numbers would show as 0.124, 0.134 and 0.130 respectively. Shown below are examples:

PowerCharts XT automatically formats your numbers by adding K,M (Kilo, Million) and proper commas to the numbers. Shown below is an example:

In the above image, the data for chart is 12500, 13400 and 13300. PowerCharts XT automatically formats the number scaling to convert to K (Thousands) & M (Millions). If you do not wish to truncate numbers in this manner, just use:

<chart formatNumberScale='0'...>

 "chart":{
    "formatnumberscale":"0"
       ...
  }

When you now view the chart, you will get the following output:

You can see above that PowerCharts XT is now showing full numbers on the chart. It has also added commas to the numbers at the required places. If you do not need the commas too, set formatNumber=0. But, setting formatNumber=0 will not format any decimal places too (even if explicitly specified in your data).

Shown below is an example with <chart ... formatNumber='0' formatNumberScale='0' ..> :

You can see that the commas have been removed from numbers.

By default, PowerCharts XT uses . (dot) as decimal separator and , (comma) as thousand separator character. However, you can customize this character depending on your requirements.

To do so, use the decimalSeparator and thousandSeparator attribute. For example, let's set our thousands separator as dot and decimal separator as comma. To do so, you will have to use the following data:

<chart ... decimalSeparator=',' thousandSeparator='.' > 

"chart":{
      ...
    "decimalseparator":",",
    "thousandseparator":"."
  }

Shown below is the output.

PowerCharts XT automatically decides the position of the thousand separator. By default, the thousand separator is placed after every three digits from right. A chart with default thousand separator position will look as under:

Starting PowerCharts XT, you can customize the position of the thousand separator and place it as required. To place the thousand separator in custom positions you need to use the thousandSeparatorPosition attribute. Shown below is a chart with the thousand separator placed after four digits from right:

In the above chart, the attribute thousandSeparatorPosition is set to '4'. So, the thousand separator (,) is placed after every four digits starting from right.

You can also set multiple values (separated by comma) to this attribute, instead of a single value. Thus, you can specify complex thousand separator positions. For example, specifying multiple values, you can display numbers in Indian currency format, where the first thousand separator (for thousand) is placed after three digits from right and then onwards the thousand separator is placed after every two digits. Shown below is an example chart displaying Indian currency format:

In the above chart, we have set thousandSeparatorPosition='2,3'. So, the thousand separator is first placed after 3 digits starting from right and then onwards after every two digits. Given below are some sample combinations of values which can be set to this attribute:

PowerCharts XT allows you to add a prefix or suffix to all numbers on the chart. You can use the following attributes of the <chart> element to attain the same:

• numberPrefix="$": Using this attribute, you could add prefix to all the numbers visible on the graph (plotted on primary axis). For example, to represent all dollars figure on the chart, you could specify this attribute to ' $' to show like $40000, $50000.
• numberSuffix="p.a": Using this attribute, you could add a suffix to all the numbers visible on the graph. For example, to represent all figure quantified as per annum on the chart, you could specify this attribute to ' /a' to show like 40000/a, 50000/a.

To know more on how to use currency symbols (£, €, ¥, etc.) refer to the Using Currency Symbols page. If you intended to use special punctuation or characters like &, <, >, % , etc. refer to the Using Special Punctuation page.

Examples:

If you have opted to manually set the number of divisional lines on chart, you can also control the decimals of y-axis values separately. For example, consider the following data and chart:

<chart yAxisMinValue='115' yAxisMaxValue='140' adjustDiv='0' numDivLines='3' >
   ...
</chart>

{
  "chart":{
    "yaxisminvalue":"115",
    "yaxismaxvalue":"140",
    "adjustdiv":"0",
    "numdivlines":"3"
  },
  ...
}

The chart for this XML/JSON looks as under:

In this chart, we have manually fixed the chart lower limit, upper limit and number of divisional lines. We have also asked PowerCharts XT not to automatically adjust divisional lines. Now, if you see the chart, you will find that PowerCharts XT has truncated decimals from y-axis values, as it could not find any other decimal values on the chart.

You can, however, opt to just show decimals on y-axis values in this case (when adjustDiv is false) using forceYAxisValueDecimals='1' and yAxisValueDecimals='number' attribute.

Example:

<chart yAxisMinValue='115' yAxisMaxValue='140' adjustDiv='0' numDivLines='3' forceYAxisValueDecimals='1' yAxisValueDecimals='2' decimals='0' > 

 "chart":{
    "yaxisminvalue":"115",
    "yaxismaxvalue":"140",
    "adjustdiv":"0",
    "numdivlines":"3",
    "forceyaxisvaluedecimals":"1",
    "yaxisvaluedecimals":"2",
    "decimals":"0"
  }

When you now see the chart, you will get 2 decimal places on y-axis values.

Next, we will see how to utilize the number scale formatting properties provided in PowerCharts XT.