I've managed to create an excel workbook, sheet and line chart. I can't get the x-axis range to plot to be what I want nor the "series" to graph to be what I want. I get the chart to come up in excel and I can tweak it to work, but no macro recording spells out the vb code for me.

The big problem is I cannot access all the excel objects. I've trial and error'd a few, but can't get at them. For example, when I execute code similar to this to change the series names for plotting:

Dim oChart as Object...

oChart.SeriesCollection(1).Name = "MYNAME"

I get "error 1004, cannot access SeriesCollection class of chart object" (or something close to that).

Any ideas?