pivot chart page field

  • Thread starter Thread starter Bob
  • Start date Start date
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
 
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.
 
Back
Top