View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.charting
Bernard Liengme Bernard Liengme is offline
external usenet poster
 
Posts: 4,393
Default Can Excel graph a line from an equation? y=3x+2

If you know the functions why plot to find intersection?
y=mx+b
Y=MX+B
At intersection y=Y and x=X
so: mx+b=Mx+B;
therefore x=(B-b)/(m-M) and y=m(B-b)/(m-M)+b
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email

"GraphLady" wrote in message
...
Can Excel do linear programming problems? I'm wondering if Excel can graph
from an equation rather than data points and can it identify points of
intersection?