Forum Discussion

Deborah Huston's avatar
Deborah Huston
Copper Contributor
Oct 23, 2018

Excel graphics in MS Access

I have an interactive report in Access but the graphics are so limiting, can I export a table to an Excel chart template and somehow export the graphic back to Access - maybe using an unbound object within Access?  

Charting
excel

1 Reply

  • JKPieterse's avatar
    JKPieterse
    Silver Contributor
    Oct 24, 2018
    Probably easiest is to connect an Excel file to your query and create the chart from the data. Then call Excel from your code to open that file and update the query from Excel.