How to Use an Option Button in Excel

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.

Edit name

You can change the text on Option Button. Just right click go to Edit Text and change it.

Edit Text

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.

Cell Link

Cell linked


Using Option Buttons in Excel you can easily create your own survey in Excel. Here you have screenshot with example on survey in Excel.

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:

chart with options

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.

chart with option button enabled

Unchecking the option:

chart with option button unmarked

Further reading: 
Chart with if statement
Chart with option buttons
Chart with a single x-axis but two different ranges