Copy pie chart into new tabs, and show the results from data on those tabs

I have created a file with 15 tabs. The layout and formulas are the same on each tab; just the data is diffferent tab-to-tab. I have set up a pie chart and formatted it the way I want on the first tab.

I want to have the same style of pie chart appear on each of the tabs, but when I copy and paste onto one of the other tabs, I get the data from the first tab displayed by the pie. Surely I don't have to edit the data selection on every tab??

I just want each tab's pie to copy what the pie on the first tab is doing.

Will be very grateful for advice on how to avoid this tedious process!

Save the first pie chart as a template. Then you can highlight the data series and apply that specific, per-formatted chart on all the other tabs.

Note this doesn't dynamically update all the charts on the rest of the tabs to always match how the first tab is formatted, which I think might be what you want?

Thanks, ben_hensel. That saves a lot of work.