Sounds like an interesting challenge, so here’s some airware…
It would be nice if charts in Access had an event for Series Point values but I can’t find any.
But the MouseMove event does work over charts in Access even if the chart is de-activated. The MouseMove works over the entire chart area but I think we would need to determine where, if at all, the mouse is over the plot area.
So that would be the first challenge, from the X/Y single returned from the chart MouseMove event calculate where it is over the plot area. Now given the plot area position and using the X and Y axis value range, use a DLookup on the data source to determine the nearest data value. Depending on the chart type the X axis of the chart should be increasing monotonically so it becomes the major axis. Then use that to find the nearest value on the Y axis which relates to the value on the X axis.
If that can be done, either get the value and display it in a common text box, or, switch the point value on for that series. The common text box would be easier and faster because charts in Access are not going to win first place is any speed contest.
So it should boil down to: -
1. Calculating where the mouse is over the plot area.
2. Using the X and Y axis value range, get the nearest value from the data source.
3. Display the data in a common text box.
And please remember, I did say it was airware.
