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

Automatically adjusting chart reference
 

See Tushar Mehta's site for a short course on Dynamic Charting and some sample
files.

http://www.tushar-mehta.com/excel/ne...rts/index.html

Alternative site is Stephen Bullen's.

http://www.oaltd.co.uk/Excel/Default.htm

Download either or both of FunChrt1 and FunChrt7


Gord Dibben MS Excel MVP


On Tue, 15 Jul 2008 10:18:03 -0700, Tim C
wrote:

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