how do I change cell references automatically in formulas

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

Guest

In Excel 2000, I have data in 80 rows and 10 columns. Each week I add a new
row. I have a separate chart for each column with the data range from the
first row to the last.. Each week I have to change the data range to reflect
the new last row for each chart. Is there someway I can do this
automatically?
 
Back
Top