Pivot Chart: Remove "Drop Page Fields Here" box

[celine]

I've created a Pivot Chart and have arranged the items as I like them. Users should be able to still click on items and turn on or off individual pieces of data. I'm currently not using any items in "Page Fields," simply because it doesn't seem to do what I want.

How can I remove the blue-bordered label: "Drop Page Fields Here" from the graph? If not possible, what is Page Fields for? Perhaps I could use it after all.

Thanks!

[Andy Pope]

Check here.
http://www.contextures.com/xlfaqPivot.html#DropPage

[celine]

Thanks for your reply andy.

if i choose PivotChart>Hide PivotChart Field buttons then All buttons will go off.

I want to show all buttons except that text box. Will it possible ?
Pls advice

Thanks a lot.

[Andy Pope]

I think it all or nothing.

[celine]

thanks andy.

I mean all pivot chart field buttons are gone.

Hope no way to remove drop that text box.

Anyway can anyone clarify me anonther query

once i click pivot chart field buttons a small window popsup which contains all values with "Show All". Is there any posibility of removing that "Show All" from that window.

Thanks a lot.

[Andy Pope]

No the field selector is a builtin control that can not be customised.

[celine]

Appreciate for your guidence andy.

Thank you so much.