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-

Below is the Pivot chart which we have created –
