Format painter graph excel

A useful trick when using Excel charts or graphs is a format painter graph. Excel allows you to use the format painter on cells by simply clicking on the icon. For graphs it is slightly different.

Create your graph in the way you want. If you now want to copy these formats to another graph, click on the graph and COPY it (right click and copy or CTRL C or whatever way you prefer)

Click on the next graph. Now click on the PASTE SPECIAL option under the HOME tab.

You will notice that a different box appears from the normal Paste Special box which asks whether you want to paste all, formats or formulas. Choose Formats and you will have painted the format onto a new graph.

For more attend one of our graphing or dashboard courses