How to feed Access Chart object with data?

[ShannonE]

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

[Matt_T_hat]

Originally posted by ShannonE
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.

What!? surely that is an issue that needs to be addressed with the user / your boss.

[ShannonE]

not gonna happen... it would take way too long to install that control on everyones computers and take weeks of paperwork. The Govt. has a much more conservative security policy than your average company

[Matt_T_hat]

Originally posted by ShannonE
The Govt. has a much more conservative security policy than your average company

That's not so nice...

You could try creating a linked chart in Excel (auto-updates when cell values change) and feed the data to the cells from the db. but that just seems a bit like driving down the M1 to pop next door.

[ShannonE]

Originally posted by Matt_T_hat
That's not so nice...

You could try creating a linked chart in Excel (auto-updates when cell values change) and feed the data to the cells from the db. but that just seems a bit like driving down the M1 to pop next door.

Cool, I never knew the charts in Excel could be linked to cells so that they change dynamically when the cells change. I'll give that a shot, Thanks!