| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Chart Question
Can the following be done in one line:
'============================================ ActiveSheet.ChartObjects(1).Activate ActiveChart.SetSourceData source:=Range("R30:R42") '============================================ the following seems intuitive but doesn't work: '============================================ ActiveSheet.ChartObjects(1).SetSourceData source:=Range("R30:R42") '============================================ I don't understand why the object (ChartObjects(1)?) doesn't support the property (SetSourceData?) Any help greatly appreciated. JasonQ |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Chart Question | Excel Discussion (Misc queries) | |||
| Pie Chart Question | Charts and Charting in Excel | |||
| Chart Question | Charts and Charting in Excel | |||
| 3d chart question | Charts and Charting in Excel | |||
| Chart VBA Question | Charts and Charting in Excel | |||
Threaded Mode
