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.

--
Cheers,
Shane Devenshire


"Eric" wrote:

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!