Hi all, hope you all had good holidays .

OK, I have a Pivot table and chart, the data for this is stored in another document.
I have Location as Page, Month as Rows and Year as Columns. I am after a way to change the page field while on the chart without having all the Pivot table buttons visible.
Is there a way to create/show a Page Field selection box without showing all the other Pivot table buttons.

As always,

Your help is much appreciated .

Neil