Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
I have five chart and i want to show these chart one by one using buttons.
my criteria is when i open certain tab it will hide it will shows only button then when i click one button then it will show me respective chart .
Can Anybody help me out?
Thanks
Please see the attached
see attached. i just did it for 1 chart, but you can do the same for rest.
Hi,
Check book report tab.
Please see the attached
add a variable vShow, constraint from 0 to 5
add a trigger on activate sheet to hide all charts

in all buttons (text object) add the action to set the variable (1 for chart1, 2 for chart2, etc...)

in all charts set the conditional show using the variable

Hi,
PFA - It has 5 buttons. Clicking a button displays respective chart while hiding rest.
Hi Kush ,
I tried your solution but my when i click on button then all object get minimize.
Thanks
Can you attach screenshot?.. it's working fine for me
PFA
OK, initially if your all objects are minimized. Either you maximize all objects by default
or you need to add one more action to restore the object if minimized
see the attached