Hide and Show prob?

[paulwalker]

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

[aveeeeeee7en]

Hi Paul

See the Attachment.

[aveeeeeee7en]

I am not able to open your Qvw.

[maxgro]

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

[jagan]

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.

[#6]

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

[er_mohit]

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

[#8]

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