Show in terms of 1 million

[Matthew]

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!

[Ves]

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.

[Matthew]

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