Conditional Show on Text Box depending on a Chart in a container being active

[#1]

Hi All,

This is my first discussion so forgive me if I put things in the wrong place

I have 2 charts in a container object, one of which needs further explanation so I want to show a text boxonly if the chart is active. I can see that I can make use of triggers on sheet objects but only the container's Object is shown in the list and not the individual charts.

I love the new container object and will be using it a lot so I need to find a solution to this. Can anyone help me?

[#2]

There is 'Help Text' under 'Caption' in 'Chart Properties' wherein you can enter multiline comments/ explanations to provide addiotional info - did you try that?

[#3]

Thanks for this suggestion but the Help caption is still for the whole container object and not on just one chart within the container object. Any other ideas?

[#4]

Actually - you can have it for each individual chart within the container or for some charts which warrant extra info. Click on a 'particular' chart within a container right click and have your comments in there..a small question mark will then appear on the top right border indicating there's extra info available for that particular chart.

[#5]

Thanks again. Ah yes. I see now. However I'm not sure that it is intuitive for users of the document know to click on the ? to get the helpful text.

Perhaps the answer is that I need to log an idea so that it comes in a service pack/upgrade.

[ljdlumley]

Hi, I've just come across exactly the same problem. Did you ever find a way to display the text box?

I was trying to approach it by setting the Conditional Show property of the text box and then writing a formula using which 'tab' of the container was showing. Unfortunately I couldn't find a way to reference which tab was selected.

[#7]

No. Unfortunately, no one ever answered my question. Let me know if you ever find the solution!

[#8]

you could also try this: keep a copy of the object that needs a text box to be displayed - hidden. Trigger an action to show the text box on the copy of chart contained in the container. show the text box conditionally.

[phaneendra_kunc]

You can acheive the same with the Buttons too...

See attached..

Regards

Phani

[#10]

You can add a trigger to a chart BEFORE you add the chart to a container, once in the container you can’t add the trigger.

You can use the triggers to set a variable and use this to show and hide text boxes.

See attached demo

Tab 1 = charts with triggers, text boxes with show conditions but no container

Tab 2 = tab 1 with a container added