Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Pivot Chart Dual Category Axis not Preserving Formatting
I previously wrote but don't think I was clear enough with the issue I am
encountering. Hoping I can explain it better so someone can help me out. I have put together a Pivot Chart based upon a Pivot Table. The Pivot Table will have data entered monthly and the problem I am having is that the Pivot Chart is a dual category axis and when I update with new information and refresh, it changes to a single axis and I have to reformat all the information. Does this mean I am not able to use the dual axis chart without having to reformat every time? Also, I have some drop down boxes to show, e.g., just a certain month's data and that does not work anymore. Hope someone can help. I want to be able to present this Pivot Chart and click on the drop down boxes to present different parts of the data. Your input/direction is much appreciated. The good news is spring is 39 days away! Newbie |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Pivot Chart Dual Category Axis not Preserving Formatting
Hi,
In 2003 I have no problem with a dual category axis. When I refresh it it remains a dual axis. With regard to the formatting, what formatting are you doing, that isn't retained? What version of Excel are you using? When you say you have a drop down box to pick certain periods, you mean the pivot chart filters? Or have you added some custom drop downs? Mine work just fine. -- If this helps, please click the Yes button Cheers, Shane Devenshire "Newbie" wrote: I previously wrote but don't think I was clear enough with the issue I am encountering. Hoping I can explain it better so someone can help me out. I have put together a Pivot Chart based upon a Pivot Table. The Pivot Table will have data entered monthly and the problem I am having is that the Pivot Chart is a dual category axis and when I update with new information and refresh, it changes to a single axis and I have to reformat all the information. Does this mean I am not able to use the dual axis chart without having to reformat every time? Also, I have some drop down boxes to show, e.g., just a certain month's data and that does not work anymore. Hope someone can help. I want to be able to present this Pivot Chart and click on the drop down boxes to present different parts of the data. Your input/direction is much appreciated. The good news is spring is 39 days away! Newbie |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Pivot Chart Dual Category Axis not Preserving Formatting
Hi Shane, I use 2003. The formatting consist of dual axis, changing data
series colors and fonts. And I guess it is pivot chart filters..this is my first pivot table/chart. It looks awesome with the dual axis which shows total number and total percentage of data but I cannot get it to stay the same when I add more data. Maybe I should start over...??? Thank you. "Shane Devenshire" wrote: Hi, In 2003 I have no problem with a dual category axis. When I refresh it it remains a dual axis. With regard to the formatting, what formatting are you doing, that isn't retained? What version of Excel are you using? When you say you have a drop down box to pick certain periods, you mean the pivot chart filters? Or have you added some custom drop downs? Mine work just fine. -- If this helps, please click the Yes button Cheers, Shane Devenshire "Newbie" wrote: I previously wrote but don't think I was clear enough with the issue I am encountering. Hoping I can explain it better so someone can help me out. I have put together a Pivot Chart based upon a Pivot Table. The Pivot Table will have data entered monthly and the problem I am having is that the Pivot Chart is a dual category axis and when I update with new information and refresh, it changes to a single axis and I have to reformat all the information. Does this mean I am not able to use the dual axis chart without having to reformat every time? Also, I have some drop down boxes to show, e.g., just a certain month's data and that does not work anymore. Hope someone can help. I want to be able to present this Pivot Chart and click on the drop down boxes to present different parts of the data. Your input/direction is much appreciated. The good news is spring is 39 days away! Newbie |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Chart templates treates value axis as a category axis | Charts and Charting in Excel | |||
Dual x-axis chart | Charts and Charting in Excel | |||
Chart with dual Y axis data | Excel Worksheet Functions | |||
How do I change the category axis number formatting in a Pivot Ch. | Charts and Charting in Excel | |||
How do I make the Y axis in an excel chart the category axis? | Charts and Charting in Excel |