LabVIEW

cancel
Showing results for 
Search instead for 
Did you mean: 

ChartObjects SetSourceData labview Excel

Solved!
Go to solution

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

0 Kudos
Message 1 of 7
(3,596 Views)

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
0 Kudos
Message 2 of 7
(3,595 Views)
0 Kudos
Message 3 of 7
(3,588 Views)

Hi,

 

Unfortunetly this doesn't work.... 

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

 

thanks for answer

0 Kudos
Message 4 of 7
(3,575 Views)
Solution
Accepted by topic author sallesa

Hi sallesa,

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

 

Mike

0 Kudos
Message 5 of 7
(3,566 Views)

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

 

 

0 Kudos
Message 6 of 7
(3,562 Views)

Hi Sallesa,

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

 

Mike

0 Kudos
Message 7 of 7
(3,560 Views)