Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default Graph Simple/Quadratic equations

Is there a way to graph simple and quadratic equations in
Excel?

Alberto.
  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 17
Default Graph Simple/Quadratic equations

Alberto -

Simple answer: Put the coefficients into the worksheet, say, E1, E2, and
E3 for the constant, first order, and second order coefficients (skip
the E3 part for a linear equation). In A2 to A10 (or whatever) put the X
values you want to cover. In B2 enter this equation:

=$E$1+$E$2*A2+$E$3*A2^2

and fill it down column B as far as you have values in column A. Now
just make an XY Scatter chart (not a Line chart) of these values.

If you want to get fancier, check out the formula charting examples on
Stephen Bullen's site (http://bmsltd.co.uk) and Tushar Mehta's site
(http://tushar-mehta.com).

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
http://PeltierTech.com/Excel/Charts/
_______

Alberto Tejada wrote:

Is there a way to graph simple and quadratic equations in
Excel?

Alberto.


  #3   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 27,285
Default Graph Simple/Quadratic equations

put a formula representing the equation in a sheet and refering to the cell
to the left
File the formula down for as many points as you want to graph

put x values in the adjacent cell.

Graph the two columns using an X-Y scatter plot

Excel graphs numbers, so one way or another you have to feed the graph
numbers.

--
Regards,
Tom Ogilvy

"Alberto Tejada" wrote in message
...
Is there a way to graph simple and quadratic equations in
Excel?

Alberto.



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
can quadratic equations be solved in excel gavla Excel Discussion (Misc queries) 3 April 21st 10 09:48 PM
equations on appropriate graph scales Jon Excel Discussion (Misc queries) 0 November 15th 08 08:43 AM
How can I graph quadratic or quartic equations raidven Charts and Charting in Excel 6 November 1st 06 03:32 PM
How do I enter a quadratic and cubit-fit equations? DianeD Charts and Charting in Excel 1 May 12th 06 09:35 PM
2 variables in 2 quadratic equations in excel [email protected] Excel Discussion (Misc queries) 3 February 6th 05 07:23 PM


All times are GMT +1. The time now is 05:21 PM.

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"