Number Formatting Problem
FusionCharts Forum
Home       Members    Calendar    Who's On
Welcome Guest ( Login | Register )
        



Number Formatting Problem Expand / Collapse
Author
Message
Posted 5/7/2008 9:23:03 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: Forum Members
Last Login: 5/12/2008 8:07:33 AM
Posts: 3, Visits: 10

Hi,

I am using the ScrollCombiDY2D.swf in my chart and doing some number formatting internally like I am plotting this number “1754.37” and showing it on PYAxis. Now its in thousand format that’s why I am getting the on PYAxis with suffix like in “3.6K” by default. But when I convert it to Million its coming “1.75437603” and in this case I am not getting anything suffix like “M” and for Billion its forming “0.00175437603” here I should expect like “B” suffix to the PYAxis.

 

Here I am giving the following coding which I am following.

 

chart.setShowValues("0");

chart.setDecimals("2");

chart.setFormatNumber(new BigDecimal(1));

chart.setSFormatNumberScale("1");

chart.setSFormatNumberScale("1");

chart.setNumberScaleValue("1000,1000,1000");

chart.setNumberScaleUnit("K,M,B");

 

I need to display on PYAxis like “M” & “B” Format.

 

Kindly give me some solutions for this issue.

 

Thanks & Regards,

Sanjaya Kumar Das

Post #6127
Posted 5/12/2008 6:17:03 AM
FusionCharts Team

FusionCharts TeamFusionCharts TeamFusionCharts TeamFusionCharts TeamFusionCharts TeamFusionCharts TeamFusionCharts TeamFusionCharts Team

Group: Administrators
Last Login: 7/2/2008 7:57:52 PM
Posts: 1,956, Visits: 468
Hi,

Can you please post the output XML as attachment?


Thanks,
Pallav Nadhani
FusionCharts Team
Post #6191
Posted 5/12/2008 8:21:53 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: Forum Members
Last Login: 5/12/2008 8:07:33 AM
Posts: 3, Visits: 10

Please find the xml file as below:

<?xml version="1.0" encoding="UTF-8" standalone="yes"?><chart xaxisname="Month" useRoundEdges="1" showValues="0" showFCMenuItem="0" showBorder="0" sFormatNumberScale="1" numberScaleValue="1000,1000,1000" numberScaleUnit="K,M,B" formatNumber="1" decimals="2" bgColor="FFFFFF" SYAxisName="Sales Value&#xA;Sales Target" PYAxisName="Actual to Target Sales %"><categories><category label="DEC"></category><category label="NOV"></category><category label="OCT"></category></categories><dataset seriesName="Actual to Target Sales %"><set value="0" toolText="Actual to Target Sales %&amp;lt;BR&amp;gt;DEC&amp;lt;BR&amp;gt;0.00"></set><set value="251.27" toolText="Actual to Target Sales %&amp;lt;BR&amp;gt;NOV&amp;lt;BR&amp;gt;251.27"></set><set value="251.66" toolText="Actual to Target Sales %&amp;lt;BR&amp;gt;OCT&amp;lt;BR&amp;gt;251.66"></set></dataset><dataset seriesName="Sales Value" renderAs="Line" parentYAxis="S"><set value="48701.99" toolText="Sales Value&amp;lt;BR&amp;gt;DEC&amp;lt;BR&amp;gt;48,701.99"></set><set value="31360527.05" toolText="Sales Value&amp;lt;BR&amp;gt;NOV&amp;lt;BR&amp;gt;31,360,527.05"></set><set value="31409229.04" toolText="Sales Value&amp;lt;BR&amp;gt;OCT&amp;lt;BR&amp;gt;31,409,229.04"></set></dataset><dataset seriesName="Sales Target" renderAs="Line" parentYAxis="S"><set value="0" toolText="Sales Target&amp;lt;BR&amp;gt;DEC&amp;lt;BR&amp;gt;0.00"></set><set value="12480918" toolText="Sales Target&amp;lt;BR&amp;gt;NOV&amp;lt;BR&amp;gt;12,480,918.00"></set><set value="12480918" toolText="Sales Target&amp;lt;BR&amp;gt;OCT&amp;lt;BR&amp;gt;12,480,918.00"></set></dataset><styles><definition><style type="font" size="10" name="MyFirstFontStyle" font="Arial" color="000000"></style><style type="font" name="toolName" isHTML="1" bold="1"></style></definition><application><apply toObject="Caption" styles="MyFirstFontStyle"></apply><apply toObject="TOOLTIP" styles="toolName"></apply></application></styles></chart>

kindly let me know the solution.

Post #6222
Posted 5/18/2008 9:55:08 AM
FusionCharts Team

FusionCharts TeamFusionCharts TeamFusionCharts TeamFusionCharts TeamFusionCharts TeamFusionCharts TeamFusionCharts TeamFusionCharts Team

Group: Administrators
Last Login: 7/2/2008 7:57:52 PM
Posts: 1,956, Visits: 468
This XML seems to give an error - can you please resend a valid one at support [at] fusioncharts.com

Thanks,
Pallav Nadhani
FusionCharts Team
Post #6294
« Prev Topic | Next Topic »


Permissions Expand / Collapse

All times are GMT -7:00, Time now is 3:23pm


Execution: 0.156.