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