how to chart various categories to compare

I would like to make a chart/charts that shows the following data but cannot work out how as I have multiple entries for "Company A, Company B" and am not very good with Excel.
From the following spreadsheet it shows various Companies that have received quotes, and from these quotes some we have won and some we have lost, with various revenue values and profit against them.

Is there a way of showing/comparing this data easily in graph format?
eg. can you compare each company against each other for number of quotes, number won and number lost?
Compare each company for total revenue/profit and showing the % of profit against the revenue?
Compare the number of companies that we quote and who don't ever order against those that do order?

I've attached the sheet I work from, so any assistance on how best to compare/correlate the info I would very much appreciate it.



thanks,

Maybe what you are looking for is a simple Pivot Table? I created one in your workbook. A search of the web will give you instructions on how to create one (they are easy).
You can create a graph from the pivot table and just filter by whichever companies you want to compare. You can filter from the pivot table or directly on the chart.
Is this what you are looking for?

My example spreadsheet contained a graph on a separate sheet.

My example spreadsheet contained a graph on a separate sheet.
In my pivot table, "Customer" was moved to the rows field, "Status" was in the Columns field and then "Status" was also moved to the SUM Values field.

Sorry, I uploaded the corrected workbook (in post 2) I filtered (as an example) on companies A,B,C and D