Making a comparison chart with Excel 2007

**agharbawi** · 03-28-2009, 05:14 AM

Hi All,

I'm trying to do a chart that compare the ages of a group. For example I have 10 entries in the table with some ages repeated. I want to be able to see how many are 30 years old and put it in a graph to compare.

An example set:

user1 -- 30
user2 -- 32
user3 -- 30
user4 -- 20
user5 -- 20
.
.
.

I want a pie that shows that I have 2 thirty years old and compare it to others and so on..

Please help I'm kinda new in graphs for Excel. I'm using Excel 2007

Thanks
Alaa G

**Andy Pope** · 03-28-2009, 08:02 AM

You need to summarize the data before charting it.

Assuming you data is in A2:B6 then use the following formula

for 30 year olds
=COUNTIF(B2:B6,30)

for not 30 years old
=COUNT(B2:B6)-COUNTIF(B2:B6,30)

The second part of the second formula can be a reference to the cell rather than a repeat of the formula.

You can now chart the 2 values.