Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello
I have 4 buttons on sheet 1 and 4 graphs on sheet 2
If the user clicks on button 1 on sheet 1, I want graph 1 to show on sheet 2
Then if the user clicks on button 2 on sheet 1, I want graph 2 to show on sheet 2
Could some kindly tell me if this is possible, and how I would go about achieving this technique
Kind Regards
Helen
On this topic, there must be a thousand example documents available in the community. But here is one that tries to demonstrate everything about connecting buttons to objects by way of variables, toggling object visibility, replacing objects with other objects and setting button labels depending on the visibility of an object.
Enjoy!
Peter
Yes, this is possible.
The best method to let buttons control the visibility of objects, involves variables. Variables are available everywhere, so you can hide an object inb the sale sheet, on the next sheet or on all sheets at the same time.
Create four variables. Each variable will control the visibility of a single chart on sheet 2.
To every button, add a External->Set Variable action that toggles the value of a specific variable. Use a formula like:
=IF (vVariable1 = 0, 1, 0)
In every chart on sheet 2, enable conditional show and put the corresponding variable in the expression field. For chart 1, enter vVariable1 in the field.
If you want to show only a single chart at a time, add three more actions to every button that reset the other variables to 0, and change the action expression for this button simply to value 1
Best,
Peter
On this topic, there must be a thousand example documents available in the community. But here is one that tries to demonstrate everything about connecting buttons to objects by way of variables, toggling object visibility, replacing objects with other objects and setting button labels depending on the visibility of an object.
Enjoy!
Peter
Hello
Thank you for your suggestion
With your help I was able to put the action of v_selected = 1
v_selected = 2
v_selected = 3
v_selected =4
In the actions tab of the buttons, along with activate sheet
In the conditional show on the graph on sheet 2 I just referenced the variable as suggested I.e. v_selected = 1
Thanks for your help
Helen