This is a migrated thread and some comments may be shown as answers.

Show in terms of 1 million

2 Answers 27 Views
Chart (Obsolete)
This is a migrated thread and some comments may be shown as answers.
Matthew
Top achievements
Rank 1
Matthew asked on 16 Nov 2008, 01:02 AM
I have a line chart that shows values ranging from 1 to 50 million. I can't change the values coming from the stored procedure so I need to figure out how to "divide" my resulset so that it shows in terms of 1 million. I'd like to show 3 decimal places if possible. So in other words:

1,234,000 = 1.234 m

Of course, the reason why I'm doing this is because the 7 and 8 digit numbers are too long and they start running over each other. I appreciate any and all advice. Thanks in advance!

2 Answers, 1 is accepted

Sort by
0
Ves
Telerik team
answered on 18 Nov 2008, 07:25 AM
Hi Matthew,

You can use the DefaultLabelValue property of ChartSeries. It should be set to a string like this: "#Y{<format_string>}M". In this value #Y stands for the value, the format string is then added in curly braces and a literal M is added in the end. The format string could be any Standard or Custom numeric format string. In this case you can set DefaultLabelValue to "#Y{##0,,.###}M". Hope this helps.

All the best,
Ves
the Telerik team

Check out Telerik Trainer, the state of the art learning tool for Telerik products.
0
Matthew
Top achievements
Rank 1
answered on 19 Nov 2008, 12:28 AM
That worked...just to spell it out for all the newbies out there like me...

You can find the settings here:
http://img397.imageshack.us/img397/3338/settingsjy2.png

And this is what it looks like:
http://img406.imageshack.us/img406/3695/milliondh8.png
Tags
Chart (Obsolete)
Asked by
Matthew
Top achievements
Rank 1
Answers by
Ves
Telerik team
Matthew
Top achievements
Rank 1
Share this question
or