Copying formatting from one chart to another

[jplank]

If I have two charts in my excel spreadsheet and both use the same data series, and the data series are both labelled the same in each chart, is there a way to copy the formatting from one chart to the other? i.e. I want the colours selected for each data series in one chart to match those in the other chart. Is there a simple way to achieve this?

 

[Dryver14]

One option is to save the chart type as a template...Right click save as template then create second chart again then in design mode select change chart type and go to templates and use that