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.
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
To see the full course contents click here.