ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   How to plot a graph from an equation (https://www.excelbanter.com/excel-discussion-misc-queries/16347-how-plot-graph-equation.html)

tee

How to plot a graph from an equation
 
I am trying to plot a graph on the excel from an equation like y=x^2 + 2x +
1. Does anyone know how to do it? If so, please show me the light. Thanks
in advance.

Michael

Assuming you use column a for x and column b for column y, type your x values
and then in b2 type: =a2*a2+2*a2+1 and copy down for as many x values as you
have. Select the data in columns a & b and choose line chart from the chart
options (click on the chart icon on the standard tool bar for chart options).
HTH


"tee" wrote:

I am trying to plot a graph on the excel from an equation like y=x^2 + 2x +
1. Does anyone know how to do it? If so, please show me the light. Thanks
in advance.


Michael R Middleton

Better to use an XY (Scatter) chart type, not a Line chart type.

- Mike www.mikemiddleton.com

"Michael" wrote in message
...
Assuming you use column a for x and column b for column y, type your x
values
and then in b2 type: =a2*a2+2*a2+1 and copy down for as many x values as
you
have. Select the data in columns a & b and choose line chart from the
chart
options (click on the chart icon on the standard tool bar for chart
options).
HTH


"tee" wrote:

I am trying to plot a graph on the excel from an equation like y=x^2 + 2x
+
1. Does anyone know how to do it? If so, please show me the light.
Thanks
in advance.





All times are GMT +1. The time now is 07:02 PM.

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