Copy the format of one chart to another chart

Please sign up for the course before starting the lesson.

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.

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

Format Painter for Charts

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

Format Painter for Charts

To see the full course contents click here.

Back to: Advanced Excel Course > Charting In Excel