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 ???
Solved! Go to Solution.
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.
Unfortunetly this doesn't work....
Most like SetSourceData do not receive the good refnum ...
thanks for answer
attached example works for me. Don't forget to close all reference at the end. 🙂
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
it could be that there are some language differences. For me the attached example works.