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 table

Select the data and create a chart and change chart type to combo and make product2 and product 3 as line charts with secondary axis.

custom combination

Finally the chart will look like this and product 2 and product 3 are have secondry 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 unshow 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 checkboxes 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 unremove the product2 and product3

chart with checkboxes

Further reading: 
How to Add Dynamic Range to Chart? 
How to Break Chart’s column? 
Chart with option buttons