Most valuable professional
  • Excel Book Excerpt

Excel Display an Axis in Millions Using the Layout Tab’s Built-in Menus

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

Display an Axis in Millions
Using the Layout Tab’s Built-in Menus

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

LE10001044.jpg 

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

Strategy: Microsoft added many popular choices to the Labels, Axes, Background, and Analysis groups of the Layout ribbon tab. These popular settings often allow you three- to five-click access to settings without having to venture into the complex Format dialogs.

Choose Layout, Axes, Primary Vertical Axis, Show Axis in Millions.

LE10001045.jpg 

Figure 1014 Here, the choice you need is in the list.

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

LE10001046.jpg 

Figure 1015 The zeroes are replaced with “Millions”.

Gotcha: Although the built-in menu choices on the Layout tab are easy to use, they do not represent the complete set of choices. See the next topics for an example.

<-Previous Topic                    Next Topic->

For more resources for Microsoft Excel: