Automatically updating ranges in charts

  • Thread starter Thread starter Tom Rietz
  • Start date Start date
T

Tom Rietz

Hello,

Can someone help me with this. I have a set of charts
based on a table of data, say, A1-D300. Periodically, I
add data to the bottom of the range. For example, the new
range is A1-D310. I want update the ranges in the charts
so, right now, I either have to click on each data seris
and change D300 to D310 for end of the range or click on
data range and change the end of the range for each series
that way.

Is there a way to get excel to graph to the end of the
range automatically? Maybe there's a function that can go
in to the range instead of "D300" or "D310" or something?

Thanks.

Tom
 
Back
Top