click on a Graph and go to other sheet

[#1]

I'm trying to create a action where a click on a graph (situated at a MAIN sheet with 6 other Graphs)

Takes you to another sheet with detailed information. On this detailed sheet there's a button which takes you back to the MAIN sheet.

I can set this action on the Sheet properties / Triggers window (OnActivate - Add a action)

But then my problem is that when user returns on the MAIN sheet and clicks the SAME graph again NOTHING happens cause object is allready Activated (with previous click)

So is there a way to do this?

[jonathandienst]

I assume that the users are not interacting with the graph, other than clicking on it to change sheets...

If that is the case, you can overlay a transparent text box and change the sheet in the text box's action. Set the layer of the textbox in the Properties | Layout so that it is on a layer above the chart object. Now clicking anywhere on the graph (actually the text box) will fire the action.

Tip: make the box semi transparent and keep the border until you are satisfied with the layout and action.

Jonathan

[#3]

Jonathan, thanks for your input...

is this the only way??, cause this leads to another 6 objects which need to be maintained.

Is it not do-able somewhere in the GRAPH it self

[shumailh]

First try deactivate the current object (which u are clicking) by activating other object or sheet. u need to add another action on the graph to activate sheet object.. on activate----->add action----> add----> layout---- activate object or activate current sheet.... try this i hope it will work.

Shumail

[#5]

while coming to main sheet from sheet you can deactivate the sheet object using the sheet object id.. I think it will work.since you can access object id from other sheets also