how to draw a line chart from a linear equation?

G

Guest

Hi,

How do I plot a line chart from a linear equation (say, 5x + 10y = 100)? The
equation has been created using Equation Editor 3.0 object.

Thanks & regards,
Jai Raj Nair
Bangalore,India
 
B

Bernard Liengme

You cannot use Equation Editor for anything other than to <display> an
equation.


In A1 enter the text x,in B1 enter y
In A2:A21 enter 1,2,3..... (use Edit fill)
We need to rearrange your equation to y = -0.5x+10
In B2 enter =-0.5*A2+10
Copy this down to B21 - easiest way is to double click the B2 fill-handle
(box in lowed right corner)
Select with mouse cells A1:B21; click Chart Wizard tool, select XY chart and
follow the Wizard to the end.


Maybe time to read a book to get familiar with Excel
Best wishes
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Adding a linear equation to my groovy scatter plot. 10
Linear trendline:wrong equation 11
Excel graphed trendline does not match derived equation 5
Equation of a straight line on excel 1
how do I graph a linear equation? 3
How to draw chat by entering equation 5
how to add linear line to the graph 1
Extracting Constant from Non-linear Trend line 1

Top