Share [Social9_Share]

A Check Button Chart !

Check Button Chart

I guess I don’t have to say much to get your interest!! Interested..? Ok lets begin! ¬†ūüôā

Here is our data

Check Button Chart1

Three companies with Market Capitalization (in simple words the worth of the company) figures for 5 years. Apart from the data we need 3 more things

  • A Line Chart – Which is not too¬†difficult ūüėČ
  • The Check Boxes – We’ll create these in a moment
  • A technique to connect the Check Boxes to the Chart

 

Creating Check Boxes

Check Button Chart2

  1. For creating the Check Boxes you first need to Activate the Developer Tab
  2. In the Insert drop down you will find the Check Box. Make sure to choose the one under¬†Form Controls¬†and not the one under Active X Controls (I’ll talk about “WHY” sometime later)
  3. The mouse cursor will turn like a + plus sign. Simply drag to draw a check box
  4. And then create 2 more copies of the Check Box. One for each company

 

Check Button Chart3

Quick Tip: To select the check box hold the CTRL key and then click on the check box

 

Linking the Check Boxes to the Spreadsheet

Check Button Chart4

  1. Select the Check Box (using CTRL key) and in the right click menu go to Format Control
  2. Link the cell link to a cell address (preferably next to the company name)
  3. Do the same for all the Check Boxes
  4. Now when you click the check box the linked cell shows TRUE (checked) or FALSE (unchecked)

Check Button Chart5

Now we need to link the linked cells to our data for which let’s prepare a quick dummy

 

Preparing Dummy Data for the ChartCheck Button Chart6

The Logic : Just like computers Excel understands TRUE as 1 and FALSE as 0

  1. To prepare the dummy data, we are multiplying the TRUE & FALSE (in the linked cells) to the actual values
  2. So when we un-check the button, the dummy values becomes 0 (i.e. number x false)
  3. And when the button is checked, the dummy value appears ( i.e. number x  true)

 

Creating a Chart with the Dummy Data

Check Button Chart7

 

  1. Select the data (companies & values) and make a line chart
  2. Click on the Check Box to pick the company you want in the Chart
  3. All you need to do is a bit of formatting to the chart to make it look sexier! [Read Chart Basics 1, Chart Basic 2 & Chart Basics 3]

 

Download the Check Button Chart

 

Some more killer Charts for you!

  1. REPT Function or the Formula Chart
  2. Stock Ticker Chart
  3. Dynamic Data Visualization
  • Sonika Singh

    Hey Chandeep,

    This is something which was very interesting that I learnt last year in one of the programs. Believe you me, my colleagues and folks were almost out of words and they all had dropping jaws. Awesome stuff for comparisons in graphs.

    Regards,
    Sonika Singh

Chandeep Chhabra

Popular Posts

© Goodly