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

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

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.

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

Thanks

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.