Access and MS Graph Question

  • Thread starter Thread starter pmw
  • Start date Start date
P

pmw

Guest
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
 

Attachments

  • graph.jpg
    graph.jpg
    30.2 KB · Views: 220
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...
 
Do you know how to go about accessing the datagrid for the graph by using code?
 
Sorry, but no I dont I have done everything I can think of not to take VBA class.
 
Download the Graphsm97 sample from the MS Download centre I'm sure you'll find it helpful
 

Users who are viewing this thread

Back
Top Bottom