Properties button

[#1]

Hello!

I have 6 pieces of chart in a sheet, and I have two buttons (button1 and button2) with button1 I want to show three pieces that these charts and Number 2 I want to show the other three diagrams.

Now I have tried several different options but I can not work so I would have to have help from the beginning

//Elin

[#2]

Hello,

try the following attachment

[jvitantonio]

Hi see example.

[#4]

hai,

Please find the attachment,

As layal kadi showed you can do it  for any number of charts .

Thanks,

RathishKumar

[#5]

Hello!

I have no way to open dockument on the job, you have the opportunity to write?

[#6]

create one variable example vshow

in button1 Action-->Extrenal--->Set variable then put vshow=1

in 1st 3 chart properties layout--->show--->condition vshow=1

in button2 change vshow=2

  other charts layout--->show-->condition vvshow=2

[#7]

Hello!

I think I got it working with a chart but I would like the button to produce three graphs at once. How do I do? I do not want to have six different buttons

[MayilVahanan · Accepted solution]

HI

Try like this

Create a variable name vShow

Create 2 buttons ->

In first button,

Action-->Extrenal--->Set variable

variable

vShow

value

1

In second button,

Action-->Extrenal--->Set variable

variable

vShow

value

0

Then

In three chart, Layout ->Show -Conditional

if(vShow =1,1,0)

Another three chart,Layout ->Show -Conditional

if(vShow=1,0,1)

Hope it helps

[#9]

use the same variable for the charts u want to show or hide at the same time