Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
I created a container box which contains chart1 and chart2.
I created text box, but I want to show it only if the chart1 is active, else text box would be hidden.
Any idea?
Thank you
BR
Martin
I am happy that it was helpfull.
Please don't forget to close the thread once you are happy with the answers you got and your problem is solved. This will help other users to find relevant answers to their questions and avoid others going to the thread and trying to help when it is not needed anymore.
On the text box properties >> Layout >> Show >> Conditional >> =GetSelectedCount(YourChartDimensionHere)
But it works when you select any selection in the chart.
Useful, but I need to set it without any chart selection, only when the chart is active.
Hi Martin,
You can use buttons with actions instead of the container as in the attached example. It is probably the easiest way and you get the same result.
I hope it helps.
Carlos
HI ,Martin
as far as i know your requirement is not possible ,
Here up to sheet level only we have ,on activating sheet we can do it by "onActivateSheet() function
go for macros to achieve
Thanks for advice.
I created transparent button over Container tabrow with your action.
I am happy that it was helpfull.
Please don't forget to close the thread once you are happy with the answers you got and your problem is solved. This will help other users to find relevant answers to their questions and avoid others going to the thread and trying to help when it is not needed anymore.