Click the chart whose formatting you want to reuse and press Ctrl + C. Click the chart you want to change, go to Home → Paste → Paste Special, select Formats and click OK. The target chart takes the source’s colours, fonts, borders and chart type but keeps its own data.
From the keyboard, select the target chart and press Alt + E + S to open the same Paste Special dialog. It doesn’t apply anything on its own: you still choose Formats and press Enter.
Choose Formats, not All, and don’t use a plain Ctrl + V on the target chart. Both bring the source chart’s data series across as well, so the target ends up plotting the wrong numbers. If that happens, press Ctrl + Z and paste again with Formats.
To format many charts the same way, or to reuse a style in another workbook or in PowerPoint, save it as a chart template. Right-click the formatted chart, choose Save as Template, then select each target chart and go to Chart Design → Change Chart Type → Templates (the tab is called Design in older versions).
Paste Special formats one chart at a time and never copies the chart’s size. Pasting formats from a bar chart onto a line chart also turns the target into a bar chart, so check the chart type after you paste.
Let’s say, with a lot of effort, you have formatted a chart, and then you realize that you have more charts to format. Applying the same formatting to all the charts means doing 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 is a few clicks with your mouse. Yes, that’s right. With the Paste Special option, you can copy formatting from one chart to another just like simple copy-pasting. Let’s learn this tip, and WOW everyone.
Steps to Copy Formatting from One Chart to Another

- First of all, right-click on the chart from which you want to copy the chart formatting.
- And then click on Copy.
- After that, click on the other chart to which you want to apply/paste the formatting, so it’s selected.
- Now, go to Home tab -> Clipboard -> Paste -> Paste Special.
- Here you have the Paste Special dialog box.
- Select Formats and click OK.
Shortcut to Copy Chart Formatting
Yes, you can use a shortcut key to do this. Just click on the chart you want to copy, use Ctrl + C to copy it, and then select the other chart. In the end, press Ctrl + Alt + V (or Alt, E, S one after the other) to open Paste Special, select Formats and press Enter to paste/apply the formatting.
Save the Formatting as a Chart Template
If you use the same formatting again and again, even in other workbooks, save it as a chart template:
- First of all, right-click on the formatted chart and click Save as Template.
- After that, give the template a name and click Save (Excel saves it in the Charts templates folder).
- Next, to use it on another chart, right-click that chart and click Change Chart Type.
- In the end, go to Templates, select your template and click OK.
You can also pick the template when you insert a new chart (Insert > Recommended Charts > All Charts > Templates), so the new chart gets the formatting right away.
Frequently Asked Questions
Can I use Format Painter on a chart?
Only for single chart elements, like the format of one series or the chart title. To copy the formatting of a whole chart, use Paste Special > Formats or a chart template.
Does Paste Special copy the chart data too?
No. With Formats, the target chart keeps its own data and only takes the formatting (and the chart type) from the copied chart.
Why does the formatting look different on the other chart?
Formatting is applied series by series. If the target chart has more series than the source chart, the extra series keep the default format, so format them by hand.
Things to Remember
- You can’t apply size from one chart to another chart.
- You have to apply formatting to every chart one by one; you can’t apply formatting to more than one chart at once.
- If you try to apply formatting from one type of chart (for example, a bar chart) to another type of chart (for example, a line chart), it will also change the type of the target chart.
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
Commenting in September 2026.
I wish I could tell you how much time and work this saved me. Great job. Thank you.
Thanks. Works with Office 360. It didn’t work in PowerPoint, so I had to paste the chart into Excel and converted It that way.
Doesnt work on excel for mac 2016 nor 2019 either. Just replicates the new pie with the previous data. Thanks for trying_ Would be SO great if it did.
Doesn’t work for me, only formats the chart are not the plot area.
doesnt work on all versions. I tried this and it just copied the data to the next chart.
thank you, very much
you save me many hours doing one and the same
it was of great help..thanks
Thank You! You don’t want to know how many I formatted by hand before thinking to google this!
When copying the Diagram format from one document to another the format does not stay. When I close the document that I copied the format from, the document where the document was copied changes format. How can I keep the format intact so that it does not change?
GREAT ,THANKS
Many thanks .. You saved my time
Fantastic, I loved it
Nice Tip TQ
great tip!!!!
Thank you for this information – very helpful
Very Nice & Help Full
thanks a lot.
thanks for sharing. It’s really helpful.
Thanks for your words. Kamran
This has been super useful for me. I didn’t know that this was possible. Thanks for sharing, Puneet.
Welcome Dinesh.
tx for sharing
Thanks Inet