The user will select a particular department from a combo box. Accordingly the employee count for that department will be bifurcated across location, gender and grade.

One can add more parameters like age group, tenure etc.

Download File _Employee Count

In a particular group of option buttons , only one of the option can be selected.

For E.g :  In Gender , we can select either Male or Female.

In our example, we are using the employee headcount for a year.

Upon selecting the required quarter, the data for that particular quarter is highlighted.

Download Chart_Option Button

When we select All option, all the quarters are shown in the same colour.