How do I make a pie chart from this data?

Question

I will be using excel, for one. But the main problem I have is that I'm not sure how to divide the data. Here is the question, "Make a pie chart for each airline, each representing the percent of flights from each city for that airline." I have a list of five cities, each with two different airlines going to them. I know the total number of flights, the number of one time flights, and the number of delayed flights. Any ideas?

Answer 1

1) You need to make two pie charts -- one for each airline.
2) The instructions say you just need to show the percentage of flights FROM each city. It doesn't sound like it matters whether they are on time or delayed.
3) Take your data and look at the number of flights from each city and make a list. For example, if the first airline flies from Los Angeles (2 flights), New York (3 flights), Chicago (2 flights), Atlanta (2 flights), and Denver (1 flight), your pie would have a 20% wedge for Los Angeles, 30% for New York, etc.

Answer 2

Put your data into excel: example:
Airline City Percent
Southwest San Jose 11
Cleveland 24
etc.

Highlight the cities and percents. Insert pie chart. In the chart wizard, during step 3: Add your title, like Southwest. Then, while still in step 3, click on the data labels tag, check the box for percent. Then finish the wizard.
The end result should be a pie chart titled "Southwest" with different colored slices. Outside of each slice should be the percentage, and on the right there should be a legend that tells you what city is what color. For example, San Jose is the pink slice, and outside of the pink slice it says 11%.

Make a chart for each airline.
BTW, you have to figure out the percentages for each city using the numbers they gave you. If the total number of flights includes the one time flights and delayed flights then you just need the total number of flights. So say San Jose has a total of 100 flights, and Cleveland has 50 and Chicago has 50. Add up all the flights, equals 200. Now divide the number of flights for that city by the total number San Jose = 100/200 = .5 or 50%. Cleveland = 50/200 = .25 or 25%.

I hope that makes sense. It made a nice graph for me.