| 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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Chart Question
You also need the .Chart
ActiveSheet.ChartObjects(1).Chart.etc Regards, Peter T "WhytheQ" wrote in message ... 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 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Chart Question
On 14 Feb, 17:53, "Peter T" <peter_t@discussions wrote:
You also need the .Chart ActiveSheet.ChartObjects(1).Chart.etc Regards, Peter T "WhytheQ" wrote in message ... 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- Hide quoted text - - Show quoted text - Thanks J |
| Reply |
| 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 | |||
Linear Mode
