spot_img

Chart with Checkboxes

In this Article we will learn to create a chart with checkboxes. Lets start with creating a simple chart data. In this chart the main product1 is most import which must always be shown and others are optional.data tableSelect the data and create a chart and change chart type to combo and make product2 and product 3 as line chart with secondary axis.custom combination

Finally the chart will look like this and product 2 and product 3 are have secondary axis on the right. As it has different values than the main product it is better to show on secondary axis. Now we will create the checkboxes to show and un-show the product2 and product 3 as these are optional.

Lets define two names: series1 and series2 as follows.

define name

Here is how to define the first name.

define first name

And the second one.

define second name

Enter values as TRUE in cells F2 and F3:

enter boolean values

Create checkbox and format controls as follows:

Create checkboxes and format controls

Link series to series names created:

edit series

Now with checkboxes we can remove and unremoved the product2 and product3

chart with checkboxes

Template

You can download the Template here – Download
Further reading: 
How to Add Dynamic Range to Chart? 
How to Break Chart’s column? 
Check box
Chart with option buttons
spot_img
Previous articleAvoid Errors Using IFERROR-Everyone Should Know
Next articleLinking Text Box To A Specific Cell

RELATED ARTICLESMORE FROM AUTHOR