Hello, I'm trying to generate a specific chart every week. The data for this chart is in an Access query. I already have an excel form that makes the chart from data I manually provide. I need to embed this Excel worksheet in Access and have it automatically change the data table in the worksheet do be what the result of the query is. BUT this database needs to be stand alone, it can't require an Excel file. I know Access has a graphing tool but its garbage compared to Excel. How can I do this if I even can?

---

Reply from Alex Hedley:

You could use the techniques covered in my HTA tips here and here with a WebView in Access.