Pivot Chart Question

Good Morning all,

I have five data field items on a PivotChart. When I select to view only
one, the drop down of selections disappears and becomes a single button with
no selection options.
Any suggestions on how to prevent the drop down list from becoming a
single button? I would like to keep the drop down, and the ability to mix and
match selection combinations!

Thank you!

Unlike the Row and Column dropdowns, if you deselect an item in the Data
dropdown, it's removed from the pivot chart, and from the Data dropdown
list. To see it in the chart again, you can drag it back from the Pivot
Table Field List.

Renee wrote:
> Good Morning all,
>
> I have five data field items on a PivotChart. When I select to view only
> one, the drop down of selections disappears and becomes a single button with
> no selection options.
> Any suggestions on how to prevent the drop down list from becoming a
> single button? I would like to keep the drop down, and the ability to mix and
> match selection combinations!
>
> Thank you!


--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html