Pivot charts and pivot tables are notorious for their fragile formatting.
Update the pivot table, and any customized formatting vanishes. This
Microsoft Knowledge Base article describes the problem:
Changing a PivotChart Removes Series Formatting (215904)
http://support.microsoft.com/?id=215904
- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______
"paulan" wrote in message
...
I am trying to create a second axis on a pivot table, but it doesn't seem
to
retain this format when I save the file or chose another category in the
pivot table to view. The method I am using to set the second axis is to
right click on the data series, chose format data series, on choose second
axis on the axis tab.