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
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