Posted to microsoft.public.excel.worksheet.functions

Tim C[_3_] Tim C[_3_] is offline

external usenet poster

Posts: 5

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

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Page Break Preview Automatically Adjusting	FARAZ QURESHI	Excel Discussion (Misc queries)	1	April 11th 08 10:25 PM
Automatically adjusting Row height	JoeP	Excel Discussion (Misc queries)	1	November 26th 07 10:55 PM
Linked spreadsheet is not automatically adjusting row height?	lyngwin	Excel Discussion (Misc queries)	2	November 13th 07 02:00 PM
Automatically Adjusting Row Height in Merged Cells	MGC	Excel Discussion (Misc queries)	12	October 1st 07 08:19 PM
Automatically adjusting columns	jfg	Excel Discussion (Misc queries)	9	May 23rd 07 01:02 AM

All times are GMT +1. The time now is 10:10 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us