Posted: 6/13/2011 10:45:07 AM EDT
|
I've got a list of vehicle CO emissions and I want to produce a chart showing the % of vehicles above 160g/km, between 160g/km and 110g/km, and below 110g/km. I guess I need to use a pie chart, but I can't work out how to set the data ranges.
Can anyone help? (I'm using Excel 2010) |
|
Quoted:
I've got a list of vehicle CO emissions and I want to produce a chart showing the % of vehicles above 160g/km, between 160g/km and 110g/km, and below 110g/km. I guess I need to use a pie chart, but I can't work out how to set the data ranges. Can anyone help? (I'm using Excel 2010) Sure, What do you need to know? 
|
|
Quoted:
Quoted:
I've got a list of vehicle CO emissions and I want to produce a chart showing the % of vehicles above 160g/km, between 160g/km and 110g/km, and below 110g/km. I guess I need to use a pie chart, but I can't work out how to set the data ranges. Can anyone help? (I'm using Excel 2010) Sure, What do you need to know? Well, as you've already read the question - you've failed the audition!! 
|
|
Quoted:
Yes I think I can - you have PM Use the conditional COUNTIF(range,criteria) to count the number of vehicles below,in,above your range Work out the % (easy once you have the numbers) Pie Graph the result crude but it works Pie?......................you just got my attention. 
|