Turning an equation into a graph

#1 10-28-2005, 10:05 PM

For a school assignment I have to turn a number of equations into a graph.
for example y=-56 over 2197 (X+38.5)to the third -7 when X = -45.

HELP!!!

#2 10-28-2005, 11:05 PM

Steffi -

Here's the easy way. In column A (starting in A2) type a series of
typical X values from within the range of interest. In B2 type the
formula, referring to A2 as the variable X, and fill this down alongside
all of your X values. I can't parse your formula, but here's an example.

Suppose you want Y = 12 + 13 X - 0.003* X^2

In B2 enter this formula:

=12+13*A2-0.003*A2^2

You can fill this down by selecting B2, and double clicking on the small
black square at the bottom right of the highlighting rectangle.

Now make your chart from the data in columns A and B. Make an XY chart,
not a line chart.

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

Steffi wrote:

> For a school assignment I have to turn a number of equations into a graph.
> for example y=-56 over 2197 (X+38.5)to the third -7 when X = -45.
>
> HELP!!!

#3 10-29-2005, 10:05 AM

In article <0E0BE3FC-E703-4834-A6B1-53AC0C1319FB@microsoft.com>,
Steffi@discussions.microsoft.com says...
> For a school assignment I have to turn a number of equations into a graph.
> for example y=-56 over 2197 (X+38.5)to the third -7 when X = -45.
>
> HELP!!!
>
In addition to Jon's do-it-yourself approach, also look at
PLOT manager
http://www.tushar-mehta.com/excel/so...ger/index.html

Does something similar but concentrates its efforts where the function
is more curvy.

--
Regards,

Tushar Mehta
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions

Thread Tools	Search this Thread
Show Printable Version Email this Page	Search this Thread: Advanced Search
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)