While creating any dashboard or report you may need to maintain the same formatting of all charts in excel. Which is most time consuming task actually, but don’t worry here is the solution it will help you to copy chart format and apply it to another.
Below
are the steps to Copy chart format:
Ctrl+C: Yes, once
you have done with all formatting on one chart just select that chart and press
Ctrl+C.
Let’s look the example, suppose I have two charts one for ‘quantity’
and another for ‘amount’ data, I have done all formatting on ‘quantity’ chart
and now I want to apply same to another chart.
Now select fist chart and press Ctrl+C (or right click and
Copy/ go to HOME tab and select the copy option).
Then next step is selecting another chart where you what to
paste formatting of the first chart
- Go to Home tab and click on the small arrow below Paste
- Click on Paste special
- Select formats
- Click ok… that’s it.
Now your both charts have same formatting.
And if you have more than two charts, then select next chart
and use F4 button to copy same formatting, you don’t require to repeat all
steps.
Hope it will help you to save your valuable time...
