Sort data by years old

New Contributor

I need to sort data into a pie chart, showing items <1 year and younger and then 1-2 years, then 2-3 years and last 3+ years. 


Would anyone you have a video showing how to do this? Or maybe offer some help?


Thank you

2 Replies
best response confirmed by JC_Chase (New Contributor)


See the attached sample workbook.

I first created formulas to calculate the age in years and the age groups.

I then created a pivot table based on the data, and finally created a pivot chart based on the pivot table.

Perfect thank you!! Sorry my response was late.