View Single Post
  #2   Report Post  
Anne Troy
 
Posts: n/a
Default

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!