how do I change cell references automatically in formulas

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?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Chart Source Data 5
Scatter Plot Chart with Category 3
Dynamically Shifting Ranges 1
Chart adjustable range 2
Add a new row in Named Table (Table1) and add data from txtboxes into last empty cells based on header named of the Table1 0
XY scatter plot with more than 32000 rows in Excel 2003 0
Static Chart Data Range 2
Copying Named Ranges in Chart Series 1

Top