ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Charts and Charting in Excel (https://www.excelbanter.com/charts-charting-excel/)
-   -   Graph (https://www.excelbanter.com/charts-charting-excel/13478-graph.html)

RedLars

Graph
 
How can I using Excel 2003 draw a graph of the expression: 3x^3 + 2x^2+6x +10 ?

Thanks for any help.

Markus Scheible

Hi Lars,

afaik Excel can't calculate expressions like yours. so
first of all you should create a data range with two cells
X and Y and use as a formula in Y: "=3*F6^3+2*F6^2+6*x+10"
if F6 is your X cell... afterwards you can think about the
range where excel should show the data and fill this in
the x range... then copy down the cell formula for the y-
range and use the two ranges as source ranges of your
chart.

BTW: if you do that more than once, it would maybe be more
clever to buy a math program like Derive or WinFunction.

Best

Markus


-----Original Message-----
How can I using Excel 2003 draw a graph of the

expression: 3x^3 + 2x^2+6x +10 ?

Thanks for any help.
.


Jon Peltier

Check out these pages:

http://oaltd.co.uk/DLCount/DLCount.a...e=ChtFrmla.zip
http://tushar-mehta.com/excel/softwa...ger/index.html

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

RedLars wrote:

How can I using Excel 2003 draw a graph of the expression: 3x^3 + 2x^2+6x +10 ?

Thanks for any help.



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

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com