Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
josephinetedesc
Creator III
Creator III

Possible? trigger from a button on sheet 1 to a chart in a container in sheet 2

Hi all
Is this possible to do?  I am able to get to the second sheet - the hard bit is then trying to open the chart which in in a container...

Jo

2 Replies
jonathandienst
Partner - Champion III
Partner - Champion III

Its a simple action to activate a different sheet, but there is no action to select a specific chart in a container.

You may be able to do that with a macro, which will not work if you go to Ajax. Or you can use charts outside the container, but with a conditional show, based on a variable that can be set to a value (or toggled between 2 values) when you press the button.

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein
josephinetedesc
Creator III
Creator III
Author

Hi Jonathon

so trigger on button on sheet 1 - have a copy of the chart in the container in sheet 2 - this copy will be now be on sheet 1

do a conditional show on the button in sheet 1

Is that what you mean?

Jo