Exporting table to chart

[Ana via AccessMonster.com]

I'm creating table in Access and sending it to Excel via VBA, making chart.
It works ok, but by default in Excel I get chart type Column and I need Line.
I put
Charts.Add
ActiveChart.ChartType = xlLineMarkers
but it doesn't seems to be working... Could you tell me how to set a
different type of chart?
Thanks!
Ana

 

[Alex Dybenko]

Hi,
you can do the following trick. send your table to excel, then in excel
start macro recorder, make a chart you need, stop recorder and check what VB
code it made. Then you can make your code in Access based on this generated
code

--
Best regards,
___________
Alex Dybenko (MVP)
http://accessblog.net
http://www.PointLtd.com