Show and Hide a Chart using a button

[alec1982]

Anybody knows how can I hide and show a chart using a button.

Thxs,

[#2]

This uses a variable instead of a button, but it may be helpful. If you want a button you could always launch a macro as an action and have your macro show/hide the graph.

[MayilVahanan]

Hi

     Try like attached file

[alec1982]

That's excactly what I want but i couldn't find out how did you do it.

I see one action on the button and nothing related to it on the chart.

may you please explain it to me.

Thanks for your help.

[jeremy_fourman · Accepted solution]

You assign a value to a variable that contains the condition you wish to evaluate.

Button Properties Actions->Add Action->External Set Variable

Then within the chart properties Layout tab -> Show -> Conditional, you write an expression and check the value of the variable.

Hope that helps.

[MayilVahanan]

Hi

     In chart properties -> layout -> conditional

     in conditional , used the variable name..

[Anonymous]

follow this video

http://www.youtube.com/watch?v=PSRBtw7SYD8