How to open Excel Chart into an Active X Container

[denshie]

Hello LabVIEW Masters!

Good Day!

I currently have a project wherein I need to implement Wind Rose charts. Unfortunately, LabVIEW don't have this control (as far as I know).

Now, one way I think to implement this is by using Active X Container and inserting Microsoft Excel file which acts as a Template, wherein Wind Rose Chart is already configured. I just need to modify the raw data of this template and then, show the Wind Rose Chart on the Active X Container.

Please give some tips on how to this.. 

Or anyone know any other way to implement Wind rose charts directly on LabVIEW?

Thank you very much in advance!!!

Best Regards,

Dennis

[Sam_Sharp]

I would try looking for a .NET chart library/function which can do wind rose charts? I know there are some .NET chart/graphing libraries you can use with LabVIEW.

[denshie]

Hello Sam,

Thanks for your advice.

I've done some research on how to do this using .NET (Microsoft Charts), but windrose chart is not supported. The following link proves it:

https://social.msdn.microsoft.com/Forums/vstudio/en-US/d14f230b-baa9-44d9-9b66-a82fad32398d/polar-ch...

https://msdn.microsoft.com/en-us/library/dd489233.aspx

Would you teach me instead on how to programmatically embed Microsoft Excel (using ActiveX container) to a VI? Desperately need your help.. 

Thanks and Regards,

Dennis

[Sam_Sharp]

I didn't think it was possible, hence why I suggested looking at other options.

There is a thread here about it (and some other threads linked from there): http://forums.ni.com/t5/LabVIEW/Viewing-Excel-Sheet-in-LabVIEW/td-p/3003307/page/2

Basically, while there is an ActiveX interface for Excel, there is no ActiveX control (which is what gets put into an ActiveX container).

Searching for .NET wind rose on Google shows up some results so I assumed it was possible. You could also think about using a WebBrowser control and see if there is a Javascript library that does it.

Failing that, there's a 2D picture box and drawing controls to roll-your-own!

[denshie]

Hello Sam,

Thanks for your quick reply! 

Hopefully the 1st option can do the job. The 2nd option ( "You could also think about using a WebBrowser control and see if there is a Javascript library that does it" ) is something new to me also, while the 3rd option (using 2D picture box) will be quite tedious (not a fan of 2D picture box)..

Once again, thank you very much for your advice!

Thanks and Regards,

Dennis

[aeastet]

You can do this in Excel. I doubt that you are going to get someone to give you the code. You are going to have to be proficient in using LabVIEW to do what you are looking to do. I would look at some examples of what you are going to need to do here:

http://forums.ni.com/t5/BreakPoint/Excel-Board/m-p/379682/highlight/true#M2391

I would also tell you that when I am doing things like this I use MS MSDN. Even though it does not give LabVIEW examples it tells you the classes to look for and is very helpful in developing this kind of thing.

[Bob_Schor]

Have you looked at LabVIEW's Polar Plot with Point Option function?  It's found on the Graphics and Sound palette, and basically makes a "picture" (a 2D Image) of your graph.  Will this suffice?  If so, no need for Excel (except maybe to get the points into LabVIEW).

Bob Schor

[Joe_H]

As for the Excel portion, there is a whole bunch of examples here on the forum.For more information and some sample VI's and tool kits, you can go to the excel board