# How To Change Thousand To Millions?

8 replies to this topic

Junior Member

• Members
• 13 posts

Posted 17 January 2011 - 09:50 AM

Hi to all,
Please guide me how to change fusion chart values thousand to millions.
Now when i use fusion chart in vb6 it gives values in thousands but i want to convert it in millions.
so please tell me how to do this.???

Waiting for you immediate response.

Regrds,

### #2 Guest_Angie_*

Guest_Angie_*
• Guests

Posted 17 January 2011 - 09:54 AM

Hi,

Welcome to FusionCharts Forum!

Hope this helps.

Junior Member

• Members
• 13 posts

Posted 17 January 2011 - 12:21 PM

Thank you so much angie.
This helps me alot.
i Have reahced till end at my solution but not get 100% solution
Am trying to find exact solution...
if you have any more suggestion so kindly refer me.

### #4 Guest_Angie_*

Guest_Angie_*
• Guests

Posted 17 January 2011 - 12:29 PM

Hi,

FusionCharts, by default, has 1000,1000 (K,M) scaling defined for all charts. It doesn't have the scaling for billions defined. Let's modify the number scaling to add billion so that the final scale looks like 1000,1000,1000 .

This scale, in human terms, would look something as under:

1000 = 1 K
1000 K = 1 M
1000 M = 1 B

Now, to convert this scale into FusionCharts XML/JSON format, you'll have to do the following:

<chart numberScaleValue='1000,1000,1000' numberScaleUnit='K,M,B' >

Hope this helps!

If this is not you are looking for, please send us a screenshot of your requirement.

Edited by Angie, 17 January 2011 - 12:31 PM.

Junior Member

• Members
• 13 posts

Posted 17 January 2011 - 12:51 PM

but i want that if my value is 1milllion (10,00000) so it should give 1 million at bar.
and if value is less than one million (9,99,999) so it giver 0.9 milion at bar..
i dont want in result in k..

### #6 Guest_Angie_*

Guest_Angie_*
• Guests

Posted 17 January 2011 - 01:01 PM

Hi,

Since XML only accepts static data, you need to provide the value in XML itself.

Ex: <set value='1000000' />

Hope this helps.

Junior Member

• Members
• 13 posts

Posted 18 January 2011 - 12:35 PM

yes it is working now please tell me how to round off ammount
for example my amount is 25.36 million so i want 25 million.

### #8 Guest_Angie_*

Guest_Angie_*
• Guests

Posted 18 January 2011 - 12:39 PM

Hi,

Welcome again to FusionCharts Forum!

Please try the same using <decimals='2'> attribute inside the <chart> element.

Hope this helps.

Junior Member

• Members
• 13 posts

Posted 18 January 2011 - 02:04 PM

ok i will try this.
there are two more problems in fusion chart.
1- when i get values of month from database it gives (1, 2 , 3 ...., 12) for months from my database.
Is there any facitly in fusion chart that it gives jan for1 , feb for 2 , mar for 3 ....... , dec for 12

2- when i make chart using bar...so it values go down
for example
consider [] equal to bar..

[] [] []
[] [] []
pa in am
ki di er
st a ic
an a

i want this

[] []
[] []
p i
a n
k d
i i
s a
t
a
n

or show pakistan in vertical??