Skip to Content
author's profile photo Former Member
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

Add a comment
10|10000 characters needed characters exceeded

Related questions

1 Answer

  • author's profile photo Former Member
    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

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      Hi Prashant,

      In your fomula you wrote

      =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

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.