Mar 28 2022 11:03 AM
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
Mar 28 2022 11:24 AM
SolutionSee 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.
Mar 28 2022 11:24 AM
SolutionSee 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.