ChartDirector for ASP/COM/VB contains a library to create charts, and an OCX (ActiveX) control to display the generated charts and supports tooltips and hot spots on the chart. The library can be used for 64-bit applications. Many of our customers use it with Microsoft IIS (Internet Information Service) on 64-bit Windows to create web applications.
The ActiveX control can only be used in 32-bit applications. However, it is not mandatory to use the control. For desktop applications (like office applications), one way is to create the chart as an image file, and then use the standard Microsoft VBA controls to display the chart image, such as the Microsoft Image control.
I happened to have a real-time chart VBA example for Microsoft Excel. It is an Excel spreadsheet with chart that updates in real-time with random data. It requires the machine to have ChartDirector for ASP/COM/VB installed. The spreadsheet should work in both 32-bit and 64-bit Excel.
For your case, you are using MS Access, but I think the code structure should be similar. The code should be like:
‘ Create the ChartDirector API object
Set cd = CreateObject("ChartDirector.API")
' Create a XYChart object
Set c = cd.XYChart(600, 400)
.... configure the chart as usual ....
‘ Display the chart using the Microsoft Image control
fName = Environ("temp") & "test.bmp"
Image1.Picture = LoadPicture(fName)
The drawback of the Image control is it does not have built-in support of tooltips and hot spots. If you must have tooltip and hot spot support, there is an undocumented ImageMapHandler object in the ChartDirector API that can help. It can determine which hot spot is under a given coordinate. You can handle the mouse move event of the Image control, use the mouse coordinates to determine the hot spot under the mouse, put the tooltip text in a standard TextBox control, and position the TextBox to follow the mouse. This can emulate the tooltip. If you need more information, please let me know.