Data table vs Axis value abbreviations

  • Thread starter Thread starter Rita Palazzi
  • Start date Start date
R

Rita Palazzi

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
 
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!
 
Thanks for letting folks know you've solved your problem. :)

--
Regards,

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