How to Use an Option Button in Excel

In this lesson you will learn how to insert Option Button (aka Radio Button) in Excel. Option button allows you to select one option from a group of options. Here's how to use an option 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. Click and drag on the worksheet to draw the option buttons. You can create as many option buttons as you need.

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

To link an option button to a cell in Excel, you can use the "CELL" function. The value in the cell will change when you select a different option button, allowing you to use the value in other parts of your worksheet.


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.

To perform an action when an option button is selected, you can assign a macro to the option button. To do this, right-click on the option button and select "Assign Macro."

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