Problem with button action

[#1]

Hi All,

If i have 2 charts which i have auto-minimized, and i have a 1 line text below each chart specifying what the chart depicts, so when the chart is displayed, i want the text to be displayed too.

How can i expand/collapse the text with the chart?

Thanks!

[#2]

I dont want to add buttons for this. Only when someone clicks on the chart, its text should automatically also be displayed.

So i guess we wil have to write something in the layout -> conditional part of the chart. Like specify the object ID. But what is the syntax for this?

[erichshiino]

Hi,

Can you include a text inside the chart so they move together?:

You can include on in Chart properties-> Presentation -> Then "Text in Chart" -> Add...

After you create you text, you can move it clicking on the chart, then holding Ctrl+Shift and you will be able to move the label.

Hope this helps,

Erich

[#4]

Hey Eric,

The text is in a seperate text object. I cannot put it in the chart. But thanks for your suggestion!

[#5]

hi,

You can minimize the chart and text box both in same time.

right click on sheet -> properties--> trigers

select the chart object on edit action

click on add --> layout -->minimize object

enter the chart object ID at object ID input box

click on add --> layout-->minimize object

now enter the text box object ID here

Note: You sholud change the text box object properties too.

right click on text box --> properties -->caption

check the allow minimize check box.

this will help you.

Sumit

[#6]

Hi Sumit,

Thanks for your response!

So i know how to auto minimize the chart. But i only want the text to be displayed when the chart is displayed. So i guess ill have to just link the text object with the chart n vice versa.

How can i do this? i dont want to auto minimize the text object.

[tanelry · Accepted solution]

Try this...

Set up a variable vHelpText.

Then add your text object with formula =vHelpText

Then open sheet properties > Triggers

In the Sheet Object Event Triggers add triggers to each chart:

OnActivate - add Set Variable command to write relevant text into variable vHelpText

OnDeactivate - add Set Variable command to write empty string into variable vHelpText

Now the text box shows relevant text as soon as chart is activated.

You can auto-hide the text box with show condition: len(vHelpText)>0

Alternatively (more simple) use Caption > Help Text in the chart properties and teach your users to click the big "?" in the chart's upper right corner for advice.

[#8]

The help text is a perfect solution!!

Thanks soo much!