I have a text object (being used as a RAG) which I would like to activate a chart on another sheet using event action whilst at the same time switching to aforementioned sheet which the object is clicked.
Switching to the sheet works OK but the chart remains inactive. I have tried both 'Activate Object' and 'Maximise Object' with both being the first action to do before the switch and also the last but the chart remains inactive. I could set a trigger on the other worksheet to open the report when the sheet is activated but I need all the reports minimised on each sheet as the User can view activate the sheets themselves.
Morning, I've managed to resolved the issue. I basically have a dashboard with Red, Amber Green Text Objects. These are determined by the results of a calculated base colour. What I wanted the user to click on a text object and redirect them to the underlying data in the report for further analyse.
As the charts for the data are in a container I have to order the actions to restore object for the container and restore object for the chart and then activate the sheet the are on.
