7 Replies Latest reply: Aug 1, 2011 10:31 AM by ggoyal_123 RSS

    Problem with button action

      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!

        • Problem with button action

          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?

          • Problem with button action

            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

              • Problem with button action

                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.

              • Problem with button action
                Tanel Rüütli

                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.