Problem: My numbers are in millions. I am wasting a lot of space showing all of those zeros along the vertical axis.
- 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 axis Display Units.
Results: Excel removes the zeros and adds a label indicating that the numbers are in millions.
- The zeroes are replaced with "Millions".