Images loading below. While you wait, can you answer this Excel related tip? Guess the answer then click SEE ANSWER to see how it can be done.

1. How do you take all the formatting from chart (see 1 below) and PASTE it onto another chart (2)? Guess and then see how it can be done with 'See Answer'

2. What is the shortcut to ONLY select the visible cells? Guess, then click 'See Answer' as it can be done.


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