pivot chart page field

B

Bob

Does anyone know if there is a way to hide all the Pivot
Chart field buttons on a Pivotchart but still display the
page field drop down? when i hide the field buttons they
all go away, including the page field that i would like to
remain.

thanks
 
D

Debra Dalgleish

If you choose to hide the field buttons, all are hidden, including the
page fields. You could locate the pivot chart on the same sheet as the
pivot table, and use the page fields in the pivot table to manipulate
the chart.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top