In this article we will create Excel charts with option buttons, It will work like when we click the options the graph will change as per the requirements.
Let us start by creating chart data for the same. Now we can clearly see that there are 2 categories of products. A simple graph will look like this:
Now we will start creating the options for the same. We created new columns which have the following formulas:
So based on value in cell j1 it can be product2 or Products A
For based on value in cell j1 it can be product3 or Products B
So now we have added a checkbox and linked it to the cell j1 and in the graph we have changed the series types including product1 and last 2 column products which can vary.
Unchecking the option: