Draw chart in excel from access table

Hi all,

I have a Ms Access Database that contains tables.
I want to draw a gragh in Ms Excel for the data in Ms Access table.
I want to draw the graph/chart using macro/vba code.

I have no idea on how to do it.
Any reference or suggestion will be very much helpful.

Thanks in advance.

are you doing the vba code in excel or access

in either case, try recording a macro in excel to create the chart from the date, then adapt the generated code to your vba macro