Data table vs Axis value abbreviations

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!

Rita Palazzi wrote:
> 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
>

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

In article <3FC3880B.5020205@fedex.com>, rmpalazzi@fedex.com says...
> 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!
>
> Rita Palazzi wrote:
> > 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
> >
>
>