Comparing Multiple Data

Hi,

I have a couple of questions please.

1. What is the easiest way to present the following information into a graph to compare the revenue and profit won over each quarter for the year 2014 and over the year 2015 -

List of companies (Lets say 15)
Revenue and profit data from 2014 and 2015 for the months Apr/May/June.

2. Also, I have a table with the date quoted in the first column, different companies in second column, Won/Quoted/Cancelled in third column, Revenue amount in fourth column, amount of Profit in 5th column. How can this be easily manipulated so I can see the number of companies that we are quoting but not winning deals with?

Any help step by step much appreciated.