03-03-2009 02:57 AM
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
Solved! Go to Solution.
03-03-2009 03:03 AM - edited 03-03-2009 03:04 AM
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
03-03-2009 03:15 AM
Hi sallesa,
see also this link http://forums.ni.com/ni/board/message?board.id=170&message.id=357260&query.id=83931#M357260
Mike
03-03-2009 06:33 AM
Hi,
Unfortunetly this doesn't work....
Most like SetSourceData do not receive the good refnum ...
thanks for answer
03-03-2009 07:11 AM
Hi sallesa,
attached example works for me. Don't forget to close all reference at the end. 🙂
Mike
03-03-2009 07:34 AM
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
03-03-2009 07:44 AM
Hi Sallesa,
it could be that there are some language differences. For me the attached example works.
Mike