Pivot Table and Chart - Specific Row Grouping

tim

New member
Joined
Jul 24, 2013
Messages
18
Reaction score
0
Points
0
Excel Version(s)
2016
Hi there,

I need for my annual reporting create a graph of the Distribution of the agegroups of people attending our
workshops.
Our fundraiser wants to know how many people attend in following specific age groups: < 25 years, 26 - 30 years, 31 - 45 years, 45+.
A bit strange but he specificly asked for this.

I tried with attached excel example using grouping in pivot tables but one can only define fixed grouping,
unlike what i want.
Can anyone help me create a graph the with the specific agegroups like in the attached jpg?
Not sure if it needqs to be done with pivot table/chart ... but cannot get it to work with the normal excel graphing either.

Any help would be greatly appreciated.

Thanx heaps
 

Attachments

  • Distribution of ages.jpg
    Distribution of ages.jpg
    23.7 KB · Views: 5
  • Pivot ages.xlsx
    24.4 KB · Views: 7
Thannkx! Simple but effective ... didn't know about the frequency function.
Now extra problem ... what if only filtered (using autofilter) values are to be counted?
 
Back
Top