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...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.