In this lesson you will learn how to insert Option Button (aka Radio Button) in Excel.
To insert Option Button to your worksheet you should go to the Ribbon. Click Developer > Insert > Form Controls > Option Button.
Next draw your Radio Button with your mouse.
You can change the text on Option Button. Just right click go to Edit Text and change it.
Link with cell
To link Radio Button with cell right click and go to Format Control. Go to Control and write the address of the cell.
Using Option Buttons in Excel you can easily create your own survey in Excel. Here you have screenshot with example on survey in Excel.
These are Option Boxes in one Group Box. That's perfect way to create survey in Excel.
Just put some Option Boxes inside one Group Box. You can also copy/paste it to Word or Power Point.
How to make a chart with option button?
Let's see how to create a chart 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: