Sign in to follow this  
200West

Number Formatting Problem

Recommended Posts

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.

 

 

 

post-27759-0-64286600-1340654398_thumb.png

Share this post


Link to post
Share on other sites
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.

 

 

 

Share this post


Link to post
Share on other sites

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>

Share this post


Link to post
Share on other sites

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>

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
Sign in to follow this