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.
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.
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.
Here is how to define the first name.
And the second one.
Enter values as TRUE in cells F2 and F3:
Create checkboxes and format controls as follows:
Link series to series names created:
Now with checkboxes we can remove and unremove the product2 and product3
Further reading: How to Add Dynamic Range to Chart? How to Break Chart’s column? Chart with option buttons