Subtotal all data and display on bar graph

Hi All,

I am new to this forum, and it looks like everyone here is very helpful - so I'm hoping someone is willing and able to help me.

I am trying to get this bar chart to show the combined totals for owners and lessees. I am using Excel 2007, and have tried using a Data Table - but all it does is cram the data on top of the graph. I have attached my sheet here for you. My assignment is due 6/30 by 11:55pm PST, so any help would be GREATLY appreciated.


Thanks!