Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hy folks,
I have a conteiner with 3 charts, i need to know which chart is active!
Someone could help me?
tks a lot!!!
Create a variable vActiveChartID.
Then go to sheet properties->Triggers->Sheet Object Event Triggers. On active of chart 1 set vActiveChartID to 1 and so on for the other three charts.
This variable is now the tracker of active chart in the container.
Hope this helps,
Kiran
Kiram,
I understood your idea, but my charts are inside the conteiner object, and Triggers attend just a conteiner and not a charts inside the conteiner.
Thanks for idea!!!
Yes, just realised that. As a workaround, you can replace container with textboxes and conditional show on the charts.
Kiran.