Excel 2007 : How to make graph from non-consecutive cells

[KnowItAll123]

Input:
Week,Home Team, HScore, Away Team, AScore,Point spread, OverUnder
(Interger)(fixed string)(Interger)(fixed string)(integer)(decimal)(decimal)

Example:
1,chi,24,buf,12,-6.5,43.5
1,den,0,rad,22,-7,55
...
2,chi,34,gb,35,+7,35


Output:
Chart for each team:
Showing Opposing team, bar showing score difference, bar showing "against the spread" difference

Example: from the data above for chi
first bar would show chi-buf 24-12, a postive outcome bar above the x-axis,
next (24-6.5) - 12, a postive outcome bar above the x-axis.
next bar chi-gb 34-35, a negative outcome bar below the x-axis,
next (34+6.5) - 35, a postive outcome bar above the x-axis.

What is needed?
-Overview on how to accomplish this project?
-Use a Database? or Just a table?
-How to address dymanic charting?
-need to get team for each week to form chat, this data is
on segragated rows.

Thanks in advance.