Excel 2-axis line chart from Access

[WildHare]

Hi - I'm attempting to automate the process of sending a table to Excel and building a chart from three rows. I need to build a 2 axis line w/markers type chart, but I don't see that particular type in the list of Excel ChartType objects - I've searched the Access and Excel help files for a reference to this built in type, but can't find anything.

Does Access-Excel VBA model support this type of chart? If so, what ChartType is it?

Thanks

Jim
(PS - also placing this post in the Access VBA forum) Me? Ambivalent? Well, yes and no....
Another free Access forum:

http://www.forumco.com/jmhare

More Access stuff at

http://www.jmhare.com/wildhare2.htm

 

[xlhelp]

Perhaps I dont understand, but would not an XY scatter chart with data point connected by a line work?

 

[WildHare]

Probably - but I just got it to work after rechecking some syntax and several passes of Trial & Error... Thanks anyway.

Set objChart = objExcel.ActiveChart
objChart.ApplyCustomType ChartType:=xlBuiltIn, TypeName:="Lines on 2 Axes"

Jim Me? Ambivalent? Well, yes and no....
Another free Access forum:

http://www.forumco.com/jmhare

More Access stuff at

http://www.jmhare.com/wildhare2.htm