add data series to excel chart

[Charlie G]

I have an envelope on a chart in Excel.  I would like to add same test data to the chart.  I can open the workbook and get my data on a worksheet, but can't figure out how to add the data series to the chart using ActiveX.

[Joe_H]

This has proven to be very useful to me. Here is how I would proceed.

1. Go into excel and record a macro of exactly what you want to do.

2. Edit the macro so that you can see the code.

3. Duplicate the code in labview using properties and methods.

This will get you pointed in the right direction.

[Charlie G]

Thanks.  I did as you suggested and got hte macro.  Now I can't figure out how to emulate the ActiveChart.SeriesCollection.NewSeries command.

Thanks, Charlie

[Joe_H]

Here is some vi's that I forgot that I had for excel. In it is one vi in particular called create chart.vi have alook at it. I'm sending you the whole llb. i have not tested them in LV 8 yet.

hope they help.

[Charlie G]

Thank you very much for your help.

Charlie

[Joe_H]

Not a problem glad to be of service.