Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Steffi
 
Posts: n/a
Default Turning an equation into a graph

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   Report Post  
Jon Peltier
 
Posts: n/a
Default Turning an equation into a graph

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   Report Post  
Tushar Mehta
 
Posts: n/a
Default Turning an equation into a graph

In article ,
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
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How to link trendline equation in graph to cell? rossgus Excel Discussion (Misc queries) 2 May 11th 08 03:41 PM
How to plot a graph from an equation tee Excel Discussion (Misc queries) 2 March 8th 05 03:17 AM
Graph an Equation Michael Kintner Excel Discussion (Misc queries) 2 January 20th 05 05:51 PM
How do I create a graph from an equation and not a set of data? ashemorry Charts and Charting in Excel 1 January 20th 05 10:14 AM
how do I graph a linear equation? Throstle Charts and Charting in Excel 3 January 10th 05 05:19 PM


All times are GMT +1. The time now is 08:04 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"