3D graph to Excel

[milutin]

I would like, hopefully directly, to insert LV(8.5) generated 3D graph into excel, either as a graph or as a jpeg or bmp picture. I do send tabulated data to excel spreadsheet with out any problem.

I’ve read most of the posts and suggestions regarding similar questions, none seem to work for me. The attached graph is series of X,Y plots for some wavelength range. Summary of plots creates a 3D graph that I find difficult to export into MS Office2003 especially if I use report generation toolkit.

It’s most unfortunate that Excel application does not support 3D graph import as PowerPoint does.

Any suggestions are fine, example vi’s are most welcome.

Milutin

[milutin]

Added to this post is my 3D generated graph.

-Milutin

[Kevin_H]

Hi milutin,

Thank you for contacting National Instruments.  If you are looking for a simple way to save the graph as an image, you can try looking at the following KnowledgeBase article:

How Can I Save a Front Panel Control to a JPEG, PNG, or BMP File?

You can take that image, and place it in excel.  However, I may have misunderstood your question.  Are you looking for a way to pass the image and the data into excel directly?  Or is it ok for you to take the image file and manually place it in excel?

Regards,

Kevin H

[milutin]

Kevin, first of all thanks for the response, I was afraid that my questions will end up unanswered.

My fall back option is to generate, as you suggested, either Jpeg or bitmap image and then insert it into the excel spreadsheet. I’ve done that but it’s very impractical and I will use this option only if there is no other more elegant way to do this. Preferred, is the direct export (from LV VI) of such images into Excel. The more I search the more I’m convince that this task will be end up to be unattainium.

Thanks,

Milutin

[Kevin_H]

Hey milutin,

This can certainly be done using LabVIEW.  I was able to create an example this morning, but it does require our LabVIEW Report Generation Toolkit for Microsoft Office.  If you have this toolkit, it will be very simple to create an excel report, and add an image in there.

If you do not have the toolkit, this might be difficult to achieve.  I have been looking around at the report generation VI's that come with LabVIEW, and there are a couple that may give us the functionality you need, but so far I have been unable to produce a working example without the toolkit.  I will continue to look into the issue, and post back any results I come across.

Regards,

Kevin H

[milutin]

I do have a Report Generation Toolkit. My problem is to combine my tabulated data I send to excel spreadsheet and the MS report file that will handle the graph transfer. The two didn't want to mix. I'm currently trying not to send tabulated data separately, instead I’ll try to combine Excel easy text, excel easy table, and utilize the vi capable of importing graph to excel. That way I’ll have only one file with the header, data table, and the 3D graph.  Any suggestion or sample vi that you have will help a lot. I received an example vi from your colleague at NI. It helps a little, however it still requires separate step to generate .jepeg (or .btm) file before I can read it into the MS Report file.

This is getting more difficult to explain. I hope I’m not confusing you the issue even more.

Milutin