cannot access excel objects

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?

hi

can you explain the full coding what you have done it

waiting you response.
das

Sorry, I can't explain further and I had to move on to something else. Thanks anyway.