SECOND AXIS ON PIVOT TABLE
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. |
SECOND AXIS ON PIVOT TABLE
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. |
All times are GMT +1. The time now is 03:36 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com