Forum Discussion
Solved
Sort data by years old
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
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.
2 Replies
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.
