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 Trillions Using the More Options Choice
Problem: I need to plot numbers in trillions. Why doesn’t Excel offer a choice to show the axis in trillions?
Strategy: It does! Don’t get complacent and believe that the choices on the Layout ribbon tab are the only choices. Every fly-out menu there ends with a “More ___ Options" choice. Clicking this button will lead to the appropriate tab of the Format dialog, where you can access the full range of options. Here’s what you do:
1. Select your chart.
2. Select Layout, Axes, Primary Vertical Axis, More Primary Vertical Axis Options.
3. From the Scaling dropdown, select Trillions. The Scaling dropdown also offers the choices on the Layout tab, plus other choices, such as Hundreds.
Figure 1016 There are more choices in the dialog than on Layout.
<-Previous Topic Next Topic->
For more resources for Microsoft Excel: