Excel: Display an Axis in Millions

This page is an advertiser-supported excerpt of the book, Power Excel 2010-2013 from MrExcel - 567 Excel Mysteries Solved. If you like this topic, please consider buying the entire e-book.


Problem: My numbers are in millions. I am wasting a lot of space showing all of those zeros along the vertical axis.

  1. The zeroes along the vertical axis take a lot of space.

    Strategy: Double-click the numbers in the axis labels. In the resulting settings area, find the Display Units dropdown and choose Millions.

  2. Change the axis Display Units.

    Results: Excel removes the zeros and adds a label indicating that the numbers are in millions.

  3. The zeroes are replaced with "œMillions".

For more resources for Microsoft Excel