How to group a pivot table by age range

In this video, I’ll show you how to group data by age range.

Here we have a set of data that represents voting results.

I’ll go ahead and summarize the data in a pivot table.

Or, I can make Vote a column label and then add Gender as a row label.

For both fields, the pivot table breaks down the data using the values that appear in each field.

But what if you want to group by age?

What we’re looking at is specific results for each age.

Results for 20 year olds, 21 year olds, 25 year olds, and so on.

When the Grouping dialog box appears, set an interval that makes sense for your data.

In this case, I’ll group by 10 years.

When you click OK, you’ll see your data neatly grouped by age range.

To change the grouping, just repeat the process.