how to draw a line chart from a linear equation?

  • Thread starter Thread starter Guest
  • Start date Start date
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
 
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
 
Back
Top