Ok, for MS Access I am able to programatically feed data to an ActiveX MS Chart Control v6.0. The problem is the user doesn't have that ActiveX control installed on their machine, and installing it would require updating the registry which I'm NOT allowed to do. So I need to use the other type of chart (graph) Access provides (the chart from the Insert menu).

I've tried feeding this chart data from a 2-D array, and also directly from the Access tables using DAO, then ADO but I get errors and the project won't run in either case. Anyone know how to use VBA to feed this chart data with either a 2-D array or a recordset?

Thanks