access data to excel chart

[william2002]

I have a database in access that I have done a query on. I need to take the data from the query page in access and chart it in excel. Can anybody help me with the best way to do this? Also, after linking the excel chart to the access database, will the chart automatically update when I change the access data?

thanks,
William

 

[william2002]

still curious if anybody can help me link data from access to excel for charting?

thank you
william