Anybody knows how can I hide and show a chart using a button.
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.
Try like attached file
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.
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.
In chart properties -> layout -> conditional
in conditional , used the variable name..
follow this video
Retrieving data ...