MrExcel.com - Your One Stop for Excel Tips & Solutions

Display an Axis in Millions

June 28, 2023 - by

Display an Axis in Millions

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

A column chart with five months. The vertical axis labels on the left are taking up 18% of the width, as they spell out 35,000,000
Figure 1164. 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.

Change the Display Units from None to Hundreds, Thousands, Millions, Billions, Trillions or Ten Thousand, Hundred Thousand, and so on.
Figure 1165. Change the axis Display Units.

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

The 35,000,000 axis label is now 35 and a vertical label says Millions.
Figure 1166. The zeroes are replaced with “Millions”.

This article is an excerpt from Power Excel With MrExcel

Title photo by Matthias Jordan on Unsplash