When I create specific formats in a pivot chart, the formats are lost when I
change selections from the drop down menu. Is there an option I can select
to make sure the format settings I select are saved regardless of the changes
in selections made from the drop-down selections?

This is a known behavior of pivot charts. Microsoft suggests recording a
macro next time you reformat the chart, then replay the macro whenever
needed after that.

http://support.microsoft.com/kb/215904

This was true for Excel 2000 when the above article came out, and for every
version since.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


"mrogge2895" wrote in message
...
When I create specific formats in a pivot chart, the formats are lost when
I
change selections from the drop down menu. Is there an option I can
select
to make sure the format settings I select are saved regardless of the
changes
in selections made from the drop-down selections?

In Excel 2007 this issue was addressed to maintain formatting; but yes, the
support article applies to previous versions.
--
Thanks,
Christopher

This posting is provided "AS IS" with no warranties, and confers no rights.


"Jon Peltier" wrote:

This is a known behavior of pivot charts. Microsoft suggests recording a
macro next time you reformat the chart, then replay the macro whenever
needed after that.

http://support.microsoft.com/kb/215904

This was true for Excel 2000 when the above article came out, and for every
version since.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


"mrogge2895" wrote in message
...
When I create specific formats in a pivot chart, the formats are lost when
I
change selections from the drop down menu. Is there an option I can
select
to make sure the format settings I select are saved regardless of the
changes
in selections made from the drop-down selections?