Auto range a Chart

's Computer Specifications

I have a Chart that is set to the following ranges.....
='Sheet1'!$A$1,'Sheet1'!$A$114:$A$191,'Sheet1'!$D$1:$E$1,'Sheet1'!$D
$114:$E$191
I can right click on chart and drag the range every time I add data
but can the above be altered to range automatically from row 114
onward?

's Computer Specifications

A chart's individual series can be linked to dynamic ranges, but the total
data range cannot, at least not without VBA. Here are some examples and
links:

http://peltiertech.com/Excel/Charts/Dynamics.html

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
http://PeltierTech.com
_______

<(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
>I have a Chart that is set to the following ranges.....
> ='Sheet1'!$A$1,'Sheet1'!$A$114:$A$191,'Sheet1'!$D$1:$E$1,'Sheet1'!$D
> $114:$E$191
> I can right click on chart and drag the range every time I add data
> but can the above be altered to range automatically from row 114
> onward?
>

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Auto update the chart range for new sheets	=?Utf-8?B?QWNjZXNzIEpvZQ==?=	Microsoft Excel Charting	2	13th Dec 2007 06:42 PM
x y scatter chart series ranges reset to x(range) = y(range)	=?Utf-8?B?QnJha2VybTE5?=	Microsoft Excel Charting	4	26th Sep 2006 11:13 PM
Auto increment chart range montly	=?Utf-8?B?Y29tZnV0ZWQ=?=	Microsoft Excel Charting	1	7th Jul 2006 10:58 PM
Dynamic column chart - auto sort on data range	=?Utf-8?B?amltZnJvZw==?=	Microsoft Excel Charting	0	29th Mar 2006 02:45 PM
Auto-set Chart Data Range	=?Utf-8?B?UGV0ZSBNZXJlbmRh?=	Microsoft Excel Programming	2	5th Feb 2005 03:29 AM