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.

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.

Dynamic Charts:

http://peltiertech.com/Excel/Charts/...umnChart1.html
http://peltiertech.com/Excel/Charts/Dynamics.html

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


"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.