SOLVED

Sort data by years old

Copper 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 (Copper Contributor)
Solution

@JC_Chase 

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.

1 best response

Accepted Solutions
best response confirmed by JC_Chase (Copper Contributor)
Solution

@JC_Chase 

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.

View solution in original post