Excel Graphs - a challenging one!

[funkylad20]

OK, here is a chalenging one...does anyone know what type of graph that will show the volume of something, making it appear relative to the scope a result is grouped into?

So, I have a list of results for surveys done, for 4 different age groups:
5-15, 16-19, 20-54 and 55+.

Results =
Number of people that fall into 5-15 age bracket = 3,385
Number that fall into 16-19 = 1,155
Number of people that fall into 20-54 = 307
Number f people who fall into 55+ = 38

HOW do I show these as RELECTIVE VOLUMES? If I use a standard chart, showing the values, it isn't really a true reflection of each groups weighting, i.e. 5-15 is 10 years worth of people, 16-19 is only 4, 20-54 is 34 years worth of people, 55+ is indefinite...

[ChuckFickens]

have you considered percentages?

[scotman]

You have afinite number of graph types available. Try them till you find the one you want.

[funkylad20]

No,none of them take into consideration. Percentages might be the answer, will explore further...