Dynamic Chart with Option buttons
Charts and Visualization

Dynamic Chart with Option Button for Employees Count by Age group

In our last article, we created a Dynamic Chart with Slicer for Employees Count by Age group. Now in this article, we have created same chart with Form Control Option buttons rather than Slicer. We have created option buttons for departments. Whichever option button will be selected, it will display the data on the chart accordingly and Chart title also will be changed.

Below is the data for multiple employees with their age in years-

EMP Data
EMP Data

Below is the dynamic chart which we have created –

Dynamic Chart with Option buttons
Dynamic Chart with Option buttons

Click here to download the practice file-

 

Watch the step by step video tutorial:

PK
My Name is PK. I am founder of PK-AnExcelExpert.com. I am a Microsoft Certified Professional. I have more than 10 years of experience in Data Visualization, Excel Automation and dashboard creation. Excel is my passion and I like to do always something innovative in Excel and share it with other people.
https://www.pk-anexcelexpert.com