Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Pivot Table Drop Down Box Disappears in Chart
Good day to all, hoping someone can help me figure out how I can fix this
Pivot Table. It is my first Pivot Table and one of the Data Fields is Sum of % Compliance and the other is Sum of # Compliant. I made a chart based on the table and when you look at the chart, it shows the # of Compliant but not the % Compliance. There is a drop down box on the chart which shows both of these items but if you click on only one of them the box disappears and only a legend appears with TOTAL. I then have to go to edit to Undo Pivot to get it back. The chart will not show the % of Compliance. Hope this is understandable and someone can direct me. Aside from this, it looks great for my first table. Thanking you ahead of time for your time. Newbie |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Pivot Table drop down | Excel Discussion (Misc queries) | |||
Pivot Table Drop down | Charts and Charting in Excel | |||
chart formating disappears when i refresh pivot table data | Excel Discussion (Misc queries) | |||
second axis disappears on pivot chart when page field changed | Charts and Charting in Excel | |||
Pivot Table Drop Down Boxes | Excel Discussion (Misc queries) |