PDA

View Full Version : Pivot Table and Chart - Specific Row Grouping



tim
2016-10-10, 02:35 PM
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

hossat
2016-10-10, 04:46 PM
Hi,

You'll find in the attached file a solution by using the frequency in-built function. (Due to external data source errors, the ages are not the same).

Hope that will help you
5828

tim
2016-10-13, 03:40 PM
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?