how do you link existing excel data to new graph from labview using report generation toolkit?

[srogers]

I want to insert a new graph in an existing Excel workbook using the Report Generation Toolkit.  I can insert a new graph, but only with data from LabVIEW.  So I have to first read the data from the workbook into LabVIEW using Excel Get Data.vi and then feed the data into the Excel Insert Graph.vi (see attachment).  I would like to somehow insert a new graph into an existing workbook and then associate/link the graph's data with the data in the workbook.  Something like this:  ActiveChart.SetSourceData Source:=Sheets("mysheet").Range("B2:I25").  I'm sure if I dig deep enough, I can write all of this using the ActiveX API, but I was hoping for something higher level, like the VIs in the Report Generation Toolkit.

[MikeS81]

Hi Scott,

i don't know if there is a function in the report generation toolkit, but this link shows an example of what you need.

http://forums.ni.com/ni/board/message?board.id=170&view=by_date_ascending&message.id=391177#M391177

Hope it helps.

Mike

[Anna_K.]

Hello,

To do this with the Report Generation toolkit, you are looking at a minimum of two steps as you have in your code.

Regards,

Anna K.