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
|