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
_______


wrote in message
oups.com...
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?