View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.charting
Missy
 
Posts: n/a
Default 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.