MSCHART - enotation above value 1000000 - HELP!!!!

[ssei1]

Hi :

Using MSCHART within EXCEL. Everything works great except for the fact that when the values being plotted exceed 1,000,000 on the Y-axis the control automatically reverts to e notation (1.2e+006). I do not want my client to have to look at the numbers displayed in this format.

How do I get numbers above 1,000,000 to display normally.
If this a property setting, something I have to code...?
Any and all help will be appreciated.


Thanks in advance,
Richard

[RobDog888]

What about formatting it by reducing the values on the labels by
10,000 and adding a "k" descriptor. Like they do with memory
modules.

[ssei1]

Thanks for the reply - Could try that but really want them to see the actual number.

Thanks

[RobDog888]

Can you format the labels as text instead? Then you wont get
the scientific notation. Dont know if will plot correctly though.
Worth a try.