| 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? |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Auto range a Chart
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? |
| Reply |
| 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 | |||
Hybrid Mode
