PIVOT - Using a cell outside the table for change the grouping

Tech-Archive recommends: Fix windows errors by optimizing your registry

Hi experts,

I want to enable users with few knowledge of pivot techniques to
change the grouping of a pivot chart resp. the underlying pivot table.
The idea is, to have a changeable cell value beneath the chart to
enter the group (groups of 2, 4, 6, 5, etc...). The associated pivot
table shall change it's groupings accordingly, thus forces to change
the associated chart.

Any idea, how to achieve this?
Thanks and have a nice day
Michael
.

Quantcast