Change chart using button Object

[robert99]

Changing chart using for example a button object

Example. If I want to change a Pivot Table chart from 'Subtotals at bottom' to 'Subtotals at top'

Or remove 'Show partial sums'

I can do this by going into chart properties

But can this be done  by setting up a (say) text or button object and clicking on the object once set up

I sure it can be done but I can not see how

Thanks

[Anonymous]

Agreed.  "Thou shall not use Macro's" is one of the 5 missing commandments.

[robert99]

Thanks

I have done this before but I'm using an adhoc report and I was trying to avoid using another report

But if Macros are too be avoided and this is the only other way to do it (macros) I will do it this way

[robert99]

Thanks

I would have used this but will avoid macros.