VBA to create two bar graphs from two ODBcs

[rirus]

I have two different ODBCs which update two lists in a spreadsheet every 30 min. Using VBA I want to create two bar charts. Once create I need them to update every 30 min when the ODBCs update.
The following are the lists of data:

Case Totals
Added Date Totals
9/16/11 270
9/19/11 273
9/20/11 278
9/21/11 280

Case Open/Closed Totals
addDate Closed New
9/16/2011 3
9/19/2011 2 4
9/20/2011 1 6
9/21/2011 2 4

Also, the ODBC will update the last 30 working days of activity so the data should contain no more than 22 days of data to report on.

Thank you for any help you can send my way,

rirus