Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Auto range a Chart
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 | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Auto update the chart range for new sheets | Charts and Charting in Excel | |||
x y scatter chart series ranges reset to x(range) = y(range) | Charts and Charting in Excel | |||
Auto increment chart range montly | Charts and Charting in Excel | |||
Dynamic column chart - auto sort on data range | Charts and Charting in Excel | |||
Auto-set Chart Data Range | Excel Programming |