Excel: Chart Formatting

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.


After you create a chart in Excel 2013, click the Paintbrush icon to the right of the chart. Ten designs will appear. Choose a design. There is nothing particularly new here - all of the formatting choices were available in Excel 2010. What is new is the combinations of the formatting choices. In one episode of the MrExcel podcast, I set out to replicate a 2013 style in 2010. It was possible, but it took 56 steps.

  1. Quickly apply a style in Excel 2013 using the Paintbrush icon.