# Rearrange a formula

1. ## Rearrange a formula

How do I write a code to chart functions in this form

After arrangement
2*x+xy = 4 >> y = (4-x)/x

3+xy +x = 0 >> y = -(3+x)/x

So I just want the user to enter the function, then excel will plot it.

I know how to plot the function after it has been rearranged, but what I
don't know is how to rearrange the function to plot it

Can anybody hep

Thanx  Register To Reply

2. ## Re: Rearrange a formula

Both Stephen Bullen (http://oaltd.co.uk) and Tushar Mehta (http://tushar-mehta.com)
have "Plot Formula" utilities on their web sites. I know Stephen's works on a
formula entered as text into a cell, and I'm sure Tushar's does the same.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______

Ali Baba wrote:

> How do I write a code to chart functions in this form
>
> After arrangement
> 2*x+xy = 4 >> y = (4-x)/x
>
> 3+xy +x = 0 >> y = -(3+x)/x
>
> So I just want the user to enter the function, then excel will plot it.
>
> I know how to plot the function after it has been rearranged, but what I
> don't know is how to rearrange the function to plot it
>
> Can anybody hep
>
> Thanx  Register To Reply

3. ## Re: Rearrange a formula

My question is how to rearrange the formula to plot it. I know how to plot it.

The program by Tushar Mehta can only plot an equation of this form:
y(x) = .................

But what I want is something which allows the user just to enter any
equation of this form, for example, to get it plotted
3*xy + x =2

You may say why don't you just ask the user to enter the rearranged
equation. Well, I want excel to do the job not the user. That's why I want
your help to write the code.

thanks Jon  Register To Reply

4. ## Re: Rearrange a formula

Do you understand what you're asking? Can you envision the magnitude of
what you're asking? A routine like this which would parse a formula,
entered in any possible way, would be a huge undertaking, and I may be
understating it.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______

Ali Baba wrote:

> My question is how to rearrange the formula to plot it. I know how to plot it.
>
> The program by Tushar Mehta can only plot an equation of this form:
> y(x) = .................
>
> But what I want is something which allows the user just to enter any
> equation of this form, for example, to get it plotted
> 3*xy + x =2
>
> You may say why don't you just ask the user to enter the rearranged
> equation. Well, I want excel to do the job not the user. That's why I want
> your help to write the code.
>
> thanks Jon  Register To Reply

##### Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1