Formulas graphs & Charts

**zugfrig** · 06-03-2009, 03:13 AM

My new boss has thrown me some homework and i want to make it look impressive and also learn for future reference but need help.

i have attached the excel sheet provided.

this is in regards to aircraft cargo

we want to graph things like how many times did the cargo travel on its booked flight eg colum F shows the booked flight number and colum g shows the actual flight number how do i show say a pie graph of how many travelled as booked. i have done a simple formula in colum L that says yes or no to my question but i want to show it in a chart. also i only want it by origin airport (colum D)

also other things like a pie of colum K showing percentages of each two letter code used in the total of bookings.

and then again maybe a bar graph showing how many bookings by airline per airport, airlines are shown in colum A as a letter code or colum B as a number code with colum E being the airport code

i dont want it done for me i want to learn so if anyone can help i would be very greatful.

ta.

**Andy Pope** · 06-03-2009, 06:28 AM

Your post does not comply with Rule 8 of our Forum RULES. Cross-posting is when you post the same question in other forums on the web. You'll find people are disinclined to respond to cross-posts because they may be wasting their time solving a problem that has been solved elsewhere. We prefer that you not cross-post at all, but if you do (and it's unlikely to go unnoticed), you MUST provide a link (copy the url from the address bar in your browser)to the cross-post. Expect cross-posts without a link to be closed a message will be posted by the moderator explaining why. We are here to help so help us help you!