Creation of a automated graph with VBA

[cie00011]

I have a access form that after a series of combo boxs i get to a final name of a table within the access database.

i would like, with this selection and a button to create a line graph in either, access, excel or better the web page graph you can create. the axis will aways be load and displacement, the graph will remain a line graph, only the table name and values (ranges as well) will change.

Is there any help and code for a beginner out there?

I am trying to work at the microsoft example of creating a excel chart.

 

[llkhoutx]

Walkenbach has a couple new books out on Charting and Pivot Tables. I've seen both at Borders and Barnes & Noble. They are the first books I've ever seen specifically on charting.