Y-Axis Scale & Labeling

[datadrvn]

I've tried my best to search herein and review Jon Peltier's website and can't find what I'm looking for. Please help.

I have a straightforward line chart trending monthly spend rates by month over a year. Spend rates are in the tens of millions. The chart works well enough and the scale works fine. However, in full numeric resolution, the y-axis simply has too many digits of resolution; at $13,500,000, anything below the "13.5m" level really doesn't matter (much).

I tried to address it simply by dividing the values to get down to the right level, i.e., "13.5" and put some text in the chart title to indicate the $ are in Millions (000,000s) but that doesn't suit the readers. They would like to see the scale read in "$##.#m" format. How can I get the numberic scale right but somehow prefix the number with a $ sign and suffix the number with an "m" to denote millions and still have the scaling function work normally, i.e., some sort of dynamic scale?

 

[Andrew Poulsom]

Use the number format:

$#,##0.0,,"m"

The trailing commas scale the output by 1000 (twice).

 

[random_noise]

Have a look here:

http://blog.livedoor.jp/andrewe/archives/1222301.html


You should be able to do some thing like

.NumberFormat = "$#.#,,\m"

This will give you it in the format you want.

 

[datadrvn]

Man...I'm never disappointed when I ask for help here. The solution worked fine. I was so focused on this being a chart settings problem that I didn't think to play around more with the number format of the raw data. This opens a host of possibilities for me. Thank you so much for all your help.

A final note...I used a format of $#.##0,,"m", which was a mix of both suggestions.

Thanks again. Wayne