Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Community,
PFA,
I have 2 variables, vShow and vShow1..
i have 2 charts when i am click 1st button it show one chart and when i am click 2nd button i want to open second chart and 1st chart hide
Hi Paul
See the Attachment.
I am not able to open your Qvw.
you can use one variable, vChart
button 1 set vChart = 1
button 2 set vChart = 2
in layout tab of the charts use show conditional with expression
in chart 1 vChart=1
in chart 2 vChart =2
optional: change color of the buttons using vChart
more: n buttons for n charts: in that way you can simulate a single object container with n charts
Hi Paul,
Just use one variable vShow
and set the variable values when button1 then 1
and when button2 is clicked then 2.
Now in chart1 - Chart Properties -> Layout tab -> Conditonal - Give this condition = vShow=1
Now in chart2 - Chart Properties -> Layout tab -> Conditonal - Give this condition = vShow=2
Hope this helps you.
Regards,
Jagan.
Define one variable like vShow=1
then layou of first chart----> vShow=1 and layout of second chart--->vShow=2
first button---->action--->external---->setvariable--->vShow=1
second button--->action---->external---->setvariable----->vShow=2
regards
Mahesh T
Try this for one button
Right click the sheet and choose properties
In General tab -> Show sheet -> select the conditional and give 0 and click ok..
Sheet is hide..To view -> setting - document properties -> sheets-> select the sheet and click properties and tick to show..
or
Set variable vhide = 0. and use button to set the variable value as 0/1 by using if(vhide=0,1,0) and use vhide in conditional option in sheet properties..to show or hide the sheet..
and same for 2nd variable
Hi Paul,
1.Create variable vShow=0 and vShow1=0
2. Create button1 in properties. --> Actions tab -- click add button-- select External -- select Set variable. then in variable place vShow that is variable name and in value place 1. then click Ok
3.Create button2 in properties. --> Actions tab -- click add button-- select External -- select Set variable. then in variable place vShow1 variable name and in value place 1.then click Ok
4. Create a first chart. properties--- layout tab-- under show click condition type vShow=1. click ok
5. Create a second chart. properties--- layout tab-- under show click condition type vShow1=1 click ok.
6. when u click first button, first chart will popup. when u click second button, second chart will popup and first chart will hide., because condition is vshow1=1.
Regards,
Kanthu