Let's say, with your extreme efforts you have formatted a chart and then you realize that you have more charts to format.
Applying the same formatting to all the charts is a tedious task, the same thing again and again.
It's a pain.
The good news is: there is a super quick solution to your pain. All you need a few clicks with your mouse.
Yes, that's right.
With paste special option, you can copy formatting from one chart to another just like you do simple copy-pasting.
Let's learn this tip, and WOW everyone.
Yes, you can use a shortcut key to do this. Just click on the chart you want to copy and use Ctrl + C to copy then select the other chart.
In the end, use the shortcut key Alt + E + S to paste/apply the formatting.
Now you don't have to worry about formatting multiple charts.
You have a super quick method to copy chart formatting to another excel chart.
I hope you found this tip useful.
What do you think?
Please share your views with me in the comment section, I'd love to hear from you.
Must Read Charting Tutorials