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?