View Single Post
  #1   Report Post  
Ali Baba
 
Posts: n/a
Default How to plot a formula with two variables

Hi

I would like to plot a formula in this form
x + y = 0

I know u may say "rearrange it to y = -x" and plot it. This is not what I
want.

I tried to write a code to generate data on the worksheet but I was
unseccusseful

this is what I am trying to do

for x values,
y = -10
For x = 1 to 10
Cells(i,1) = x
Function = replace(function, "x", x)

Do
function = evaluate(replace(function, "y", y))
y = y + 0.1
loop until function = 0
Cells(i,2) = y-0.1

Next x

Can anybody help to write this code??