and in case you want to use the same button for hide and show you can set the action for vShowChart = If(vShowChart = 1, 0, 1)
you can then use the following text so that the button tells you what you want to do next:
and for your chart use conditional hide/show conditions for both your charts:
vShowChart = 1 for one chart
vShowChart = 0 for other chart
hello tammy gibson,
Thankyou for replying me.I displayed already a barchart in like =if(vshowhide=1,0,1) and give layout tab in conditional box like this vshowhide=0.it works perfectily but the problem is I displayed another line chart like this
=if(vshowhide=2,1,2) go to layout tab in conditional box i write like this vshowhide=1.but it does not work to for another chart.pls tell me out and solve my problem.pls
hello gibson ,
I fallowed as it is your instructions but it does not work to me gibson.
I explain everything about Button and bar chart with images .
- I created The first button and Bar chart like this below. it works perfectly.
- 1.General tab
I created Bar chart like this below.
4.Barchart layout tab.
5.Bar chart Layout.
The above Button and Barchart works perfectly.
2.I face the problem with another button and Line chart .see images
The below button and barchart did not work
I created 2 button like this.
1.Button 2 General tab image
2.Button 2 Actions tab Image.
3. Button 2 object image.
I created Line chart like this.
1.Line chart layout tab.
2.Line chart image.
The above chart and button did not work. pls solve my problem.
1.create variable vShowchart and value is sales click ok.
2.go to chart properties Layout tab conditional textbox give to vShowchart='sales' in the first chart.
3.create button object after action properties set variable and variable vShowchart, value is sales.
4.sheet object to create textbox object to select vShowchart varible click ok.
important while using charts Layout tab conditional textbox give to vShowchart='order' like that give to your expressions.
try once ..
Doc1.docx 387.7 K