Automatically adjusting chart reference

  • Thread starter Thread starter Tim C
  • Start date Start date
T

Tim C

Excel 2003

Current formula for chart Series 1:
=SERIES("Daily average",Sheet4!$E$2:$E$197,Sheet4!$D$2:$D$197,1)

What formula do I use so that it will automatically adjust as I add
additional rows of data?

Thanks,
Tim C
 

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

Scrabble Value calculation for Welsh words 0
Chart SERIES OFFSET 3
Chart adjustable range 2
Circular reference mistake 1
Moving data based on specific field 4
Finding the weighted average of text that have been given values 1
Sum until hit blank 7
Need help-For loop 3

Back
Top