Right-click the chart, and hit Chart Options. Go to the Scale tab, and
choose Show in Millions.
*******************
~Anne Troy
www.OfficeArticles.com
"morrowjr" wrote in message
...
Is there a formula in Excel that changes a calculated dollar figure so
that
it just shows in the 000,000's? For example, I have a calculated figure
of
$15,806,375,100. However, in my chart, I just want to show $15,806. I
there
a way for Excel to do this so that I don't have to type all my figures
manually? Thanks!