If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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. |
#2
|
|||
|
|||
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. |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
pivot table | rmsterling | General Discussion | 5 | November 14th, 2005 04:40 PM |
pivot table created from another pivot table | Kreed | Worksheet Functions | 6 | October 26th, 2005 04:16 PM |
Add New Field to DB | Karen | Database Design | 7 | October 19th, 2005 08:03 PM |
Here's a shocker | Mike Labosh | General Discussion | 2 | October 26th, 2004 05:04 PM |
Probs with creating multiple pivot charts from pivot table | Retreatgal | Charts and Charting | 2 | January 28th, 2004 02:51 AM |