Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
number formats for y-axis
I have a chart that dynamically sets the upper and lower values and
increments based on a selected series using vba script. (Thanks to previous posters and Jon Peltier for help with that!) I would now like to dynamically set the number format for the tick mark labels. For example, in one series, I may have labels of -1,000,000, -500,000, 0, 500,000, 1,000,000. In this case, I would like to format that as -1M, -.5M, 0, .5M, 1M. If I select a different series to be plotted in the same chart, the gridlines may be -200,000, -100,000, 0, 100,000, 200,000. I would like these to be formatted as -200K, -100K, 0, 100K, 200K. Any thoughts on how to conditionally set those number formats? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
number formats for y-axis
I re-posted this question in the charting group
"sasquatch" wrote: I have a chart that dynamically sets the upper and lower values and increments based on a selected series using vba script. (Thanks to previous posters and Jon Peltier for help with that!) I would now like to dynamically set the number format for the tick mark labels. For example, in one series, I may have labels of -1,000,000, -500,000, 0, 500,000, 1,000,000. In this case, I would like to format that as -1M, -.5M, 0, .5M, 1M. If I select a different series to be plotted in the same chart, the gridlines may be -200,000, -100,000, 0, 100,000, 200,000. I would like these to be formatted as -200K, -100K, 0, 100K, 200K. Any thoughts on how to conditionally set those number formats? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Number Formats | Excel Discussion (Misc queries) | |||
Number formats | Excel Discussion (Misc queries) | |||
Number Formats | Excel Discussion (Misc queries) | |||
Number Formats | Excel Discussion (Misc queries) | |||
number formats | Excel Worksheet Functions |