Dynamic Chart with Slicer
Charts and Visualization

Dynamic Chart with Slicer for Employees Count by Age group

In this article, we have created a Pivot Chart to display the department wise employees count by different age groups. We have given a slicer for departments. Whichever department will be selected in the slicer, 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-

Employees Data
Employees Data

Below is the Pivot chart which we have created –

Dynamic Chart with Slicer
Dynamic Chart with Slicer

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