Charting External Data...
 

I have an area of my spreadsheet that contains data acquired from an external
ODBC database. I have 3 charts that chart various portions of the data
returned. There are 4 series in each of the charts. I have two questions;

1) Since I do not know number of rows that will be returned how do I define
the series such that it will use all the rows returned?

2) How do I force an update of the charts when the data is refreshed?