Bar chart comparing Age and gender, filtered by date

[singarfield]

Hi, 

I am trying to present data pulled from facebook to compare the same age group clusters for females and males, across time. For this, I want to create a cluster bar chart, where the colour valued are the age groups (18-24, 25-34, etc), and where you can filter by date. However, I am not sure how I can do this with excel data. Any help?

If you have any suggestions on how to show these over time, that would be even better!

Thank you

Sara

[v-yulgu-msft]

Hi @singarfield,

You can add the [date] column into a slicer. In clustered bar chart, place [age groups] onto "axis", please [gender] into "legend" section, and place numeric field into "Values" section. 

Best regards,

Yuliana Gu