Dynamic Chart Series

HELP! I need a chart to update dynamically when I add
and resort data. It's more than just an auto adjusting
chart, since I have multiple data sets in the same table.
Specifically, I have a table with multiple wells' data,
like date, total flow, and instantaneous flow. The table
has all my wells in it and is sorted by well and date.
Currently, each well has its own chart, with absolute
series refs.

I'd like to be able to add new data to the bottom of my
table, resort, and have the charts update themselves.

I'm able to use the functions match, countif, and address to
dynamically return text with the limits of ranges for each series - I
*only* need to redo the charts' series formulae to grab
these values (which are text).

Thanks for your help! -First posting so I'd really
appreciate an emailed response, too.