Former Member

# Change values of the Chart based on Check Box

Hi All,

I am new to xcelsius.

I wish to create a Line chart which has few check box and when the check box is checked it show me

some data based on the check box label or check box .

Experts I need your help.Hope I am clear to you.

The sample is as shown in the link below

http://www.analysisfactory.com/security3.html

Regards

Prashant

10|10000 characters needed characters exceeded

### Related questions

• Former Member
Posted on Dec 12, 2008 at 09:35 AM

Hi,

You can do this by a number of methods. The easiest is to use a formula in Excel. THis will hide the value if the checkbox is unticked.

Assuming the following

You have 4 rows of data, with 12 cells in each row.

Your actual data is on a sheet called Source from A1:D12

Your checkboxes are set to write to Control:A1 to Control:A4, and checked writes a value of 1 to these.

Then you create a sheet called display and put formul

if(Control!\$A\$1=1;Source!A1;"") in Display!A1. Then copy that accross the 12 cells. So Display!A12 would look like if(Control!\$A\$1=1;Source!A12;"")

You would then repeat this for each row,. For example cell D1 would be if(Control!\$A\$4=1;Source!D1;"")

If you tied your graph to this data, and set it to ignore blanks then it should display dynamically based on the check box.

Regards

Alan

10|10000 characters needed characters exceeded
• Former Member Former Member

Hi Prashant,

=if (Control A1=0,Detination Data,"")

what is "Detination Data"

it needs to be 'Source Data'!B2 for 'Destination Data'!A2

=if (Control!\$A\$1=0,'Source Data'!B2,"")

the next cell over C2 should be

=if (Control!\$A\$1=0,'Source Data'!C2,"")

this should be copied accross to M2

=if (Control!\$A\$1=0,'Source Data'!M2,"")

if you where just showing a single line your graph should be tied to 'Destination Data'!A2:M2

The formula for a second line would be slightly different

=if (Control!\$A\$2=0,'Source Data'!B3,"")

to

=if (Control!\$A\$2=0,'Source Data'!M3,"")

and then your graph should have 'Destination Data'!A2:M3

hope this helps

Regards

Alan