Hi Mike,

You can extend your range down as far as you like, well at least as far as
the 32,000 points limit anyway.

Say your data is in A1:B100,
Set your source range to say A1:B500

That will give you more than a year before you have to reset it.
Empty cells past the end of your data won't affect the chart
until you enter a value in them.

HTH
Martin


"Mike D." wrote in message
...
Is there a quick way to update charts to include another row or column of
data in the source data? I have about 10 different charts that point to
data
in a worksheet. Each day, I have to go in and change the source data for
each series in each chart to include an additional row of data.

Thanks,
Mike.