Access and MS Graph Question (1 Viewer)

[pmw]

I am trying to create a graph that allows the user to select two points on the graph either straight on the graph or from text boxes and then once the two points have been selected a line will be drawn on the graph extending through the two points. Is this possible? If so, how? Also the graph will have two separate lines that will be created this way and I am wanting to display the point at which they intersect. Is that possible? Thanks for all you help in advance.

I attached a picture a graph that is what I want it to look like when I am finished.

Thanks,
Adam

 

[Lex]

Would it help to have a linear line on the chart that changes as the data changes?

If so in chart design right click on the data line and add a trendline

May not be selecting two points but it will print on the chart...

 

[pmw]

Do you know how to go about accessing the datagrid for the graph by using code?

 

[Lex]

Sorry, but no I dont I have done everything I can think of not to take VBA class.

 

[Rich]

Download the Graphsm97 sample from the MS Download centre I'm sure you'll find it helpful

 

[pmw]

thanks, i will give that a try.

Adam