formula for changing numbers in axis data labels?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi, I was hoping someone could tell me the formula for changing the axis
label numbers from:

$73,852,763
to
$73.9M

I tried all of the options in the custom section, but I can't seem to figure
it out.

Help please!

Thanks.
 
Genevieve said:
Hi, I was hoping someone could tell me the formula for changing the axis
label numbers from:

$73,852,763
to
$73.9M

I tried all of the options in the custom section, but I can't seem to figure
it out.
Click to expand...

Try this:

$#.0,"M"
 
Awesome. Thanks for your help!

Echo S said:
Great question!

http://msdn2.microsoft.com/en-us/library/0c899ak8.aspx helped me figure it
out.

$#,##0.0,,"M" did it for me using your example number.

--
Echo [MS PPT MVP] http://www.echosvoice.com
What's new in PPT 2007? http://www.echosvoice.com/2007.htm
Fixing PowerPoint Annoyances http://www.oreilly.com/catalog/powerpointannoy/

Genevieve said:
Hi, I was hoping someone could tell me the formula for changing the axis
label numbers from:

$73,852,763
to
$73.9M

I tried all of the options in the custom section, but I can't seem to
figure
it out.

Help please!

Thanks.
Click to expand...
Click to expand...
 
Back
Top