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
(2,830 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
(2,829 Views)
0 Kudos
Message 3 of 7
(2,822 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
(2,809 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
(2,800 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
(2,796 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
(2,794 Views)