Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
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?? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
adding row to forumla | Excel Discussion (Misc queries) | |||
dragging a formula | Excel Discussion (Misc queries) | |||
Vary variables in a formula via reference to another cell | Excel Discussion (Misc queries) | |||
Named SUM Formula with relative refernce(s) | Excel Worksheet Functions | |||
Cell shows formula and not the result of the formula. | Excel Worksheet Functions |