Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Graph Simple/Quadratic equations
Is there a way to graph simple and quadratic equations in
Excel? Alberto. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
can quadratic equations be solved in excel | Excel Discussion (Misc queries) | |||
equations on appropriate graph scales | Excel Discussion (Misc queries) | |||
How can I graph quadratic or quartic equations | Charts and Charting in Excel | |||
How do I enter a quadratic and cubit-fit equations? | Charts and Charting in Excel | |||
2 variables in 2 quadratic equations in excel | Excel Discussion (Misc queries) |