User (Legacy) Posted October 4, 2000 Report Share Posted October 4, 2000 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 Link to comment Share on other sites More sharing options...
This topic is now archived and is closed to further replies.