SECOND AXIS ON PIVOT TABLE

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
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/
_______
 
Back
Top