ChartObjects SetSourceData labview Excel

[sallesa]

Hi all,

I'm currently writing program for data from Labview to excel.

I made a template excel file with graphs in each worksheet and i want to select a given chart (2) in a given worksheet (4) to set Source Data.

My problem is that SetSourceData method do not seems to work as I use it (see Vi).

Any idea  ???

Thanks

[MikeS81]

Hi sallesa,

i'm not sure if this is the point, but you should connect the "c200" to the second input of the range method.

Hope it helps.
Mike

Message Edited by MikeS81 on 03-03-2009 10:04 AM

[MikeS81]

Hi sallesa,

see also this link http://forums.ni.com/ni/board/message?board.id=170&message.id=357260&query.id=83931#M357260

Mike

[sallesa]

Hi,

Unfortunetly this doesn't work.... 

Most like SetSourceData do not receive the good refnum ... 

thanks for answer

[MikeS81 · Accepted solution]

Hi sallesa,

attached example works for me. Don't forget to close all reference at the end. 🙂

Mike

[sallesa]

Victory ...

Indeed after ChartObjects.Index  selection, Chartobjects must be "changed" to ChartObject  and Chart must be invoked into Chartobject Property (not Diagramm as you put).

It works nice now

Have a nice day

[MikeS81]

Hi Sallesa,

it could be that there are some language differences. For me the attached example works.

Mike