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

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

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