Chelmsford Cancer Charity Quiz
Quizzes & Puzzles3 mins ago
Excel Graphs - a challenging one!
3 Answers
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...
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...
Answers
1 to 3 of 3
Best Answer
No best answer has yet been selected by funkylad20. Once a best answer has been selected, it will be shown here.
For more on marking an answer as the "Best Answer", please visit our FAQ.1 to 3 of 3
Related Questions
Sorry, we can't find any related questions. Try using the search bar at the top of the page to search for some keywords, or choose a topic and submit your own question.