Buttons and hidden objects

[Anonymous]

I have a sheet which contains 3 buttons, 1 chart and 1 pivot chart when it’s initially loaded.

The 3 buttons are labeled as “Expense by Trend”,  “Expense by Stacked” and “Expense by Other”.

When the “by Trend” is clicked, a Line Chart is used and a Piviot Chart is used.  When the “by Stacked” is clicked, a Bar Chart

and Pivot Chart are used. All these are on the same sheet. Obviously some objects are being hidden when not in use as each

object has its own Object ID.

I’m interested in finding out all the code that is behind the button click event and how the charts are “activated’ depending on

which button is pressed. Also how do I “unhide” all the objects on this sheet so I can see them in Qlikview Desktop screen.

Thank you.