Excel: The 2010 Format Dialog Box is a Task Pane in 2013

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


If you would double-click any chart element in Excel 2010, a Format dialog box would appear. Do the same thing in Excel 2013 and a Task Pane appears on the right side of the screen. While the 2010 Format dialog box was labelled with many categories, the 2013 task pane is labelled with a series of icons.

My general rule: always start with the Column Chart icon - the best choices are often there.

  1. Each circled item shows different choices below.

For more resources for Microsoft Excel