Update Charts

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
Back
Top