Formatting Y axis with custom format

[User (Legacy)]

Hi there,

I would like to apply a custom format to the Y axis. According to the help

file the following should work

    ChartFX1.Axis(AXIS_Y).Max = 100000000 'something large

    ChartFX1.Axis(AXIS_Y).Format = "##0,,"

and display the 100,000,000 as a 100. (Even I believe it should read 100,000

in the help). However, it doesn't care about the format string I give it -

it doesn't scale the axis labels. Am I doing something obvisouly wrong or

why is it not working?

Also, I would like to tell the user by what amout it was scaled. So I would

like to specify "##0,,M" as the format string, which then would display a

100,000,000 as a 100M on the chart. Is that possible??

Thanks in advance, sorry for cross-posting, didn't know exactly where it

belongs to.

Stephan

DecisionWorks London