Most valuable professional
  • Excel Book Excerpt

Excel Continue Formatting with Layout

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.

Continue Formatting with Layout

I try to do most of my chart formatting on the Layout tab of the ribbon.

“Try” is the important word there.

There are 15 dropdowns on the layout tab that cover the major elements of the chart. So far, so good.


Figure 1009 Dropdowns to format the chart.

Each dropdown leads to a tiny menu with a few popular choices. Sometimes the choices in the menu are useful. Other times, what you really need is not in the menu. However, the bottom item in each menu is for More Choices. Choose this item to get to the Format dialog box with all of the choices.


Figure 1010 The label settings that you remember from Excel 2003 are hidden beneath the More Data Label Options.

I assume that 90% of the time that I go to the Layout tab, I will have to skip the menu choices and go to the More Options choice.

<-Previous Topic                    Next Topic->

For more resources for Microsoft Excel: