LabVIEW

cancel
Showing results for 
Search instead for 
Did you mean: 

Create via ActiveX Labview a XY Scatter plot graph on an excel sheet

I am trying to plot an XY Scatter graph on an Excel sheet using LabView ActiveX function.
How do you pass the data (2 different columns)to the Graph wizard?
Thanks for any help.
0 Kudos
Message 1 of 6
(4,784 Views)
Satt,

here is a version of the VI which should work.

-Norbert B.
NI Germany
Norbert
----------------------------------------------------------------------------------------------------
CEO: What exactly is stopping us from doing this?
Expert: Geometry
Marketing Manager: Just ignore it.
Message 2 of 6
(4,784 Views)
Thanks Norbert but could you please convert the VI to Labview Version 7.0 so that I could open it.
0 Kudos
Message 3 of 6
(4,784 Views)
Satt,

Sure, here we go 🙂
Norbert
----------------------------------------------------------------------------------------------------
CEO: What exactly is stopping us from doing this?
Expert: Geometry
Marketing Manager: Just ignore it.
0 Kudos
Message 4 of 6
(4,784 Views)

Sir my values are loaded in Excel sheet. I want to retrive it and again store it in excel with XY graph.. i'm leaner so i struct hard so please help me with a VI.

It always shows an error.

 

Error -2147352571 occurred at Type mismatch.
 in XY Scatter excel plot_end.VI

0 Kudos
Message 5 of 6
(3,571 Views)

It seems the SetSourceData Method is actually expecting the value instead of the name. By choosing to input value 2,

the VI plots the data as intended. See this VBA reference page from MS.

 

Type Mismatch Troubleshooting.PNG

 

-Baalshillem

0 Kudos
Message 6 of 6
(2,709 Views)