ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Is there a way to display a graph using a equation? (https://www.excelbanter.com/excel-discussion-misc-queries/64736-there-way-display-graph-using-equation.html)

pokdbz

Is there a way to display a graph using a equation?
 
I have this equation y = 45.67 + 2.38X and would like excel to show a graph
of this, can it be done?

Bernie Deitrick

Is there a way to display a graph using a equation?
 
Sure.

Put your lowest X value into cell A2. In cell A3, use the formula

= A2 + 1

Change the 1 to the interval that you are interested in

In cell B2, use the formula

=45.67 + 2.38*A2

Copy B2 to B3, then copy A3:B3 down the column as far as your need, then use Insert / Chart and
choose XY scatter.

HTH,
Bernie
MS Excel MVP


"pokdbz" wrote in message
...
I have this equation y = 45.67 + 2.38X and would like excel to show a graph
of this, can it be done?





All times are GMT +1. The time now is 02:24 AM.

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