copy chart format

[Steve]

I have several pivot charts. On the first one I have all of the formatting
options the way I want them (e.g., fonts, colors, grid lines, etc.) Is
there a way to copy all of the formatting to another chart(s)?

 

[Gord Dibben]

First you select the first one and make it a user-defined chart type under
Custom Types.

Then you apply that to all new charts or existing charts.


Gord Dibben MS Excel MVP