View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Tim C[_3_] Tim C[_3_] is offline
external usenet poster
 
Posts: 5
Default Automatically adjusting chart reference

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