I have a chart that refers to a certain range (for the sake of arguement,
let's say "A1:C5") for its source data.

I now want to insert more data. Say before row 2. So I do a row insert,
then add my data. So now the range the chart SHOULD look at is A1:C6. But
it doesn't. Now it looks like "A1:C1;A3:C6".

Is there a way to have a chart automatically include the inserted row?

The real-world problem I'm working on has LOTS of charts already made.
Their source data is a direct references to cells on another sheet. I need
to update all of these charts with more data. I'm hoping there's some way I
can just insert a row and have it included in the chart.

Please help!

Thanks!