Copying PivotChart Formatting Excel 2007

[Eric]

So here's a new 'feature' for 2007 that I can't quite figure out. Basically,
I have 2 graphs. One is nicely formatted, the other, not at all. I'd like
to simply copy the formatting of one and paste it to the other, but cannot
figure out how to do this. In past versions of Excel, I thought that I'd
have been able to choose Paste Special, then Format, but Paste Special
doesn't work when I click on PivotCharts.

Any ideas? Thanks!

 

[ShaneDevenshire]

Hi Eric,

1. Paste Special was not available in 2003 for PivotCharts or in 2007.
2. Maybe the best solution is to create a chart template and then apply
that to future charts.

The copy and paste format command works for regular charts but not pivot
charts in both versions of Excel.

 

[Eric]

Ahh, I see.

Can chart templates be created for PivotCharts? If so, how? I don't see
the option anywhere.

Thanks!

Eric

 

[ShaneDevenshire]

Hi Eric,

1. Select the pivot chart
2. Choose PivotChart Tools, Design, Save As Template (in the Type group)
3. give it a name and you're done.

 

[Eric]

Thank you! However, this doesn't just save the formatting, it also saves the
metrics used in the chart. Is there anyway to just save the formatting; the
colors, styles, and chart type?

Thanks again,

Eric

 

[ShaneDevenshire]

Hi Eric,

Sorry to take so long getting back but yeasterday was a very long workday.

I can't duplicate your problem. When I create a chart template from a pivot
chart and then select another pivot table and launch the Create Chart dialog
box and pick template folder and then the pivot table template, the chart
that results is formatted as the original pivot chart and the data is the new
data?