Number Formatting Problem

[200West]

I'm having trouble formatting the decimal places in the 3D column chart that I'm trying to use. We are running the Fusion Charts XT paid product.

 

Here are the chart parameters:

strParam3="caption=Company Shipments;subCaption=Dollars;showBorder=1;showLabels=1;numberPrefix=$;canvasbgAlpha=0;rotateValues=1;rotateLabels=1;slantLabels=1;formatNumberScale='1';forcedecimals='1';"

 

The lablels on the left side are formatted correctly but I'm trying to change the data values to $1.48M instead of $1.482755M. When I add the parameter decimals=2 then the data values get rounded too much for example $1.482755M becomes $2M and I lose the data precision.

 

Attached is an image file. Any help is appreciated.

 

 

 

[Guest Sumedh]

I'm having trouble formatting the decimal places in the 3D column chart that I'm trying to use. We are running the Fusion Charts XT paid product.

 

Here are the chart parameters:

strParam3="caption=Company Shipments;subCaption=Dollars;showBorder=1;showLabels=1;numberPrefix=$;canvasbgAlpha=0;rotateValues=1;rotateLabels=1;slantLabels=1;formatNumberScale='1';forcedecimals='1';"

 

The lablels on the left side are formatted correctly but I'm trying to change the data values to $1.48M instead of $1.482755M. When I add the parameter decimals=2 then the data values get rounded too much for example $1.482755M becomes $2M and I lose the data precision.

 

Attached is an image file. Any help is appreciated.

 

 

 

 

 

Hi,

 

Can you paste your XML code here?

 

It would be helpful for us to look into it.

 

 

 

[200West]

Here is the XML data. Thank you for your help.

 

XML Data: <chart caption="Company Shipments" subCaption="Dollars" showBorder="1" showLabels="1" numberPrefix="$" canvasbgAlpha="0" rotateValues="1" rotateLabels="1" slantLabels="1" formatNumberScale="%26apos;1%26apos;" forcedecimals="%26apos;1%26apos;"><set value="1526531.25" label="6/19/2012" /><set value="1570983.375" label="6/20/2012" /><set value="1774865.125" label="6/21/2012" /><set value="2498688.75" label="6/22/2012" /><set value="61605.171875" label="6/23/2012" /><set value="0" label="6/24/2012" /><set value="2794867.75" label="6/25/2012" /></chart>

[200West]

Actually, I think I figured it out. I used the decimals=2 without any quotes and it seems to work perfectly.

 

XML Data: <chart caption="Company Shipments" subCaption="Dollars" showBorder="1" showLabels="1" numberPrefix="$" canvasbgAlpha="0" rotateValues="1" rotateLabels="1" slantLabels="1" formatNumberScale="%26apos;1%26apos;" forcedecimals="%26apos;1%26apos;" sDecimals="3" decimals="2"><set value="1526531.25" label="6/19/2012" /><set value="1570983.375" label="6/20/2012" /><set value="1774865.125" label="6/21/2012" /><set value="2498688.75" label="6/22/2012" /><set value="61605.171875" label="6/23/2012" /><set value="0" label="6/24/2012" /><set value="2794867.75" label="6/25/2012" /></chart>

[Swarnam]