Hi,

Some things yes, most things no:

1. To beat the color changing problem, choose Tools, Options, Color, and
change the default chart colors at the bottom. This effects every part of
the workbook.
2. Data labels can be retained, but not their formatting, by adding them via
the Chart, Chart Options, Data Labels command rather than through the Format,
Selected....

For all the rest your only solution is to upgrade to 2007 which has correct
most if not all of these problems.

If this helps, please click the Yes button.

Cheers,
Shane Devenshire

"William" wrote:

Once a Pivot Chart has been created in Excel I can edit the format of the
chart (such as changing colors, lines to bars, chart type, etc.). Once I
pivot to new information, however, the formatting is lost and the chart
returns to its original format. Is there a way I can save the format so that
the chart keeps the formatting even when I pivot the data?