Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
Can Excel graph a line from an equation? y=3x+2
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? |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
Can Excel graph a line from an equation? y=3x+2
Hi,
Have a look at Stephen Bullen's ChtFrmla example. http://www.oaltd.co.uk/Excel/SBXLPage.asp#Charting To calculate intersection you will probably need to create all the points in cells in order to use formula, which sort of negates the need for the non cell based approach Cheers Andy -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info "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? |
#3
Posted to microsoft.public.excel.charting
|
|||
|
|||
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? |
#4
Posted to microsoft.public.excel.charting
|
|||
|
|||
Can Excel graph a line from an equation? y=3x+2
Why not use points? It's easier, and you can see the data.
http://peltiertech.com/Excel/ChartsH...tEquation.html - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ "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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I graph a polar equation in Excel? | Charts and Charting in Excel | |||
how do i graph in excel from a equation?? | Charts and Charting in Excel | |||
Getting the equation of the trend line onto the excel sheet | Excel Discussion (Misc queries) | |||
How do a make a graph from an equation on excel? | Charts and Charting in Excel | |||
Excel should display linear equation of line drawn on graph. | Charts and Charting in Excel |