New graph from imported table using macro/module

[Mike M]

All I want to do is create a new graph in Design view from data in a table I
have already imported, and according to a Formula set already opened. Usually
I would do this using the Insert->Chart command, then go through the wizard
specifying what fields go to what axis, what type of graph, etc, but of
course this gets tedious having to do it every time I import a new table.

Are any of the Access macro actions given useful at all? Alternatively, I'd
like the VBA command that starts the process off. Ideally, I'd like to know a
place where the VBA command's parameters are also explained. I'm sure I've
tried all the possible macro actions, and I've searched here and Google
extensively!!!

BTW, using Access 2000.

Thanks
Mike M

 

[Mike M]

I want to create a chart from data already imported as a table in my
database, and insert it onto a form which already exists, in Design View. I
want to automate this process. Is this not possible?

Any help greatly appreciated
Mike M