Copy the format of one chart to another chart

A very useful feature in Excel is the Format painter which takes the format of a cell and uses it to paint another cell with the exact same format. You can do the same thing with a Chart but not in the same way.

To follow along go to 3.5

If we have created a bullet chart as shown below, we want to be able to re-use it on other data.

Let’s say next quarter we have 3 more months data. If we create a graph from scratch we get this. Instead of redoing all the tricks to get a bullet chart you can

• Click on the first chart
• Copy it (CTRL + C)
• Click on the second chart
• Go to HOME and click on the Paste Drop Down and choose Paste Special

• This dialogue box will appear. Choose Formats and Click OK. It will look the same and you will save yourself a lot of (re)work