Selecting a particular excel chart

[Halemani]

Hi all,

I have problem with selecting a particular chart from a set of 5 charts in one sheet. After activating I need to write some series

into the chart's Y values for plotting. The chart is XY chart. 

I tried to simulate this macro in Labview through activeX,

ActiveSheet.ChartObjects("Chart 2").Activate
    ActiveChart.ChartArea.Select

It does not work. Initially chart 5 is activated.

Take a look at my attempt.

Also, see the excel attached. I need to select any chart from that group. 

Message Edited by Halemani on 10-03-2008 04:47 AM

Message Edited by Halemani on 10-03-2008 04:48 AM

[Halemani]

Sorry about the picture. Here is the new one

Message Edited by Halemani on 10-03-2008 05:14 AM

[Michael_Munroe]

You need to wire the Excel._Chart as the target data type.  Then follow that with the Invoke node SetSourceData.

[Halemani]

Hey Micheal,

I tried doing that but the activate doesn't show up in the property or invoke nodes, strange!

So, I figured an another solution! I recorded macros to activate each sheet and then ran those macros from labview. That's it, it is working.

So, I guess macros come in handy!

Thanks anyways Micheal. Tata...