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?
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.
