Income statement annual data

Income statements are commonly shown in a combo chart, with columns plotting revenue and net income, and a line showing the profit margin as a percentage. You can see examples of this on Google's finance pages. This kind of chart is easy to make in later versions of Excel by inserting a combo chart.

The data used to create this chart is shown below:

How to make this chart

1. Select the data and insert a "combo chart"
   
2. Select the send option - columns with line on secondary axis:
   
3. The initial chart looks like this:
   
4. Select revenue columns, then set series overlap and gap with
   
5. Select legend and move to top:
   
6. Select secondary axis and set units to major units to .01 (1%):
   
7. Chart at this point:
   

At this point you can finalize the chart by setting the chart title, chart size, and font size for all text.