Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations sizbut on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Advanced(?) Graphing Question

Status
Not open for further replies.

cLFlaVA

Programmer
Jun 14, 2004
6,450
US
Hi all.

I am wondering if the following is even possible, and of course, if it is, how to do it!

I have about 20 line formulas (y = 2x + 3, etc). What I would like to do is graph each of these line formulas and then find the common intersection point.

First question, I guess, is: can I even graph a line equation in Office (preferrably excel)?

Second question, then, would be: How?

Thanks for your help.

*cLFlaVA
----------------------------
[tt]tastes great, less filling.[/tt]
 
To plot a line, you only need 2 points. Can't you create a start and end point for each equation then plot it in excel? While this is not tested, I would think solver could simultaneously solve for 20 equations to find the intersection. You could set all the x's to adjust till all the y's equal. Just a thought

Paul D
[pimp] pimpin' aint easy
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top