copy chart format
 

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)?

copy chart format
 

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

On Wed, 9 Sep 2009 09:01:01 -0700, Steve
wrote:

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)?