Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
Data Area of Pivot Table and Pivot Charts
I have a Pivot Table and Chart that has a max. of 16 fields in the Data area
that could be charted. If I deselect a field in the Data drop down box on the pivot chart or pivot table the field is completely removed and is no longer available to be selected later. How can I keep these fields available to be selected so I can chart different combinations of the 16 data fields on the chart? I am using Excel 2000. |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
Data Area of Pivot Table and Pivot Charts
Missy --
I'm using Excel 2003 so don't know if this will work in 2000, but try it. Rather than deselecting something from the PivotTable, just click-and-drag it back to the field list. Works for me. "Missy" wrote: I have a Pivot Table and Chart that has a max. of 16 fields in the Data area that could be charted. If I deselect a field in the Data drop down box on the pivot chart or pivot table the field is completely removed and is no longer available to be selected later. How can I keep these fields available to be selected so I can chart different combinations of the 16 data fields on the chart? I am using Excel 2000. |
#3
Posted to microsoft.public.excel.charting
|
|||
|
|||
Data Area of Pivot Table and Pivot Charts
Unlike Row or Column field items, if you deselect an item in the Data
dropdown, it's removed from the pivot table, and from the Data dropdown list. To see it in the chart again, you can drag it back from the Pivot Table Field List Missy wrote: I have a Pivot Table and Chart that has a max. of 16 fields in the Data area that could be charted. If I deselect a field in the Data drop down box on the pivot chart or pivot table the field is completely removed and is no longer available to be selected later. How can I keep these fields available to be selected so I can chart different combinations of the 16 data fields on the chart? I am using Excel 2000. -- Debra Dalgleish Contextures http://www.contextures.com/tiptech.html |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
keyboard shortcut doesn't work on data area of pivot table | Excel Discussion (Misc queries) | |||
Pivot table Data area show/hide behavior | Excel Discussion (Misc queries) | |||
Pivot Table macro to set print area and print details of drill down data | Excel Discussion (Misc queries) | |||
Help PLEASE! Not sure what answer is: Match? Index? Other? | Excel Worksheet Functions | |||
Change Data In Pivot Table | New Users to Excel |