Automating Excel Chart - 2 Axis Line

[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 Office 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

 

[WildHare]

Never mind - got it, thanks - See solution in the Office VBA forum if you're interested...

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