How to create dynamic dashboard in Excel using radio button

How to create dynamic dashboard in Excel using form control radio button - 5 Steps

Excel graph is very powerful tool for present complex comparisons. We often faces dispute between finance, sales, marketing and operation department over performance. Sometimes we do the business in multiple currencies. For this purpose we use different data chart formats to understand the real problem.

Sometimes in share investment we compare company performance graph/chart with other company for decision making. Here we can use form control radio button to switch the complex data.

See the below example in animated .gif image

Here we can learn how to use form control radio button to switch the chart data. 

See the below three company’s monthly average high – low trading data.

Let's Start now:

Create data in Excel like above for practice – or Click Here to download free demo excel

1) Now prepare the excel data for dynamic chart. Here we use if formula to create dynamic excel chart. see the formula below:

2) Insert radio button to switch the data between three companies.

If developer tab is not enabled - to see how to enable developer tab in excel - Click Here

3) Edit Text of radio button - right click on button > edit text

4) Insert chart using data then format it as your requirement

5) Now you have done

This way we can create beautiful dynamic dashboard to present complex comparison.