Data table vs Axis value abbreviations

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
 
R

Rita Palazzi

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!
 
T

Tushar Mehta

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Select items on data table 1
Making Data and Axis Labels Different 2
2-Axis Column Graphs 4
Two stacked bars per series 1
Trendline Issues 4
Pie chart - Showing Label AND Value 9
Text box referencing cell 11
Custom EXCEL chart value axis BRAIN TEASER 1

Top