how do I change cell references automatically in formulas
 

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?

how do I change cell references automatically in formulas
 

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

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


"jnw3" wrote in message
...
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?