Data table vs Axis value abbreviations

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Rita Palazzi - 25 Nov 2003 16:25 GMT

Windows 2000
Office 2000

I have a chart with the data table showing. The values go into the millions. On
the axis, I'd like to use e.g. $1M instead of $1,000,000. Is there a way that I
can maintain the actual value in the data table, while abbreviating the axis value?

Thanks in advance for your help
Rita Palazzi
Senior Engineer/ FedEx Express

Reply to this Message

Rita Palazzi - 25 Nov 2003 16:49 GMT

Never mind. Someone showed me the "Display Units" on the axis format menu and I
was able to do what I needed. Hope everyone has a GREAT Thanksgiving!

> Windows 2000
> Office 2000
[quoted text clipped - 7 lines]
> Rita Palazzi
> Senior Engineer/ FedEx Express

Reply to this Message

Tushar Mehta - 26 Nov 2003 14:10 GMT

Thanks for letting folks know you've solved your problem. :)

Signature

Regards,

Tushar Mehta, MS MVP -- Excel
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions

> Never mind. Someone showed me the "Display Units" on the axis format menu and I
> was able to do what I needed. Hope everyone has a GREAT Thanksgiving!
[quoted text clipped - 10 lines]
> > Rita Palazzi
> > Senior Engineer/ FedEx Express

Reply to this Message