Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Page Break Preview Automatically Adjusting | Excel Discussion (Misc queries) | |||
Automatically adjusting Row height | Excel Discussion (Misc queries) | |||
Linked spreadsheet is not automatically adjusting row height? | Excel Discussion (Misc queries) | |||
Automatically Adjusting Row Height in Merged Cells | Excel Discussion (Misc queries) | |||
Automatically adjusting columns | Excel Discussion (Misc queries) |