Tag Archives: value axis

How to Fix Those Pesky Number Formats on Excel Charts

You’ve just finished putting together the best sales report ever, but you realize that the value axis is sporting 9 digits of data instead of the cleaned up version of $1M, $2M, etc…

All I wanted to do was to show $1M instead of $1,000,000.00. Was that too much to ask for?? Is there any hope for getting the value axis formatted properly in this forsaken world of despair?!

Yes. Do not despair. It’s pretty easy, actually.

Start by right-clicking on the value axis Continue reading How to Fix Those Pesky Number Formats on Excel Charts