iamareplicant
Programmer
Experts,
I have a chart that I need to view in Access. I created the chart in Excel using the info from here:
OK. In Excel, when you run your mouse over the bell curve in the chart, you get the mouseover text that displays the values that constitute that point on the chart.
I need to be able to view that Excel chart in an MS Access form, AND be able to capture that mouseover text, or the click on that point on the curve, so that I know what value(s) consitute that point.
Hope I am making sense at this point. For testing I used an unbound control on an Access from to embed the spreadsheet I created, and I can see the chart. But the chart is dead - it does nothing. I need to make that chart both behave as it would in Excel (by having the mouseover data display the points) as well as be able to CAPTURE those values when the user clicks on that point on the chart.
I can go out to a spreadsheet and create the chart using VBA in Access, but then I need an Access form to display what I just created and have it (the chart) act as it would in Excel plus be able to capture a click over a point on the graph.
How can I do this? TIA, Jeff
I have a chart that I need to view in Access. I created the chart in Excel using the info from here:
OK. In Excel, when you run your mouse over the bell curve in the chart, you get the mouseover text that displays the values that constitute that point on the chart.
I need to be able to view that Excel chart in an MS Access form, AND be able to capture that mouseover text, or the click on that point on the curve, so that I know what value(s) consitute that point.
Hope I am making sense at this point. For testing I used an unbound control on an Access from to embed the spreadsheet I created, and I can see the chart. But the chart is dead - it does nothing. I need to make that chart both behave as it would in Excel (by having the mouseover data display the points) as well as be able to CAPTURE those values when the user clicks on that point on the chart.
I can go out to a spreadsheet and create the chart using VBA in Access, but then I need an Access form to display what I just created and have it (the chart) act as it would in Excel plus be able to capture a click over a point on the graph.
How can I do this? TIA, Jeff
