I have this equation y = 45.67 + 2.38X and would like excel to show a graph
of this, can it be done?
I have this equation y = 45.67 + 2.38X and would like excel to show a graph
of this, can it be done?
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" <[email protected]> wrote in message
news:[email protected]...
>I have this equation y = 45.67 + 2.38X and would like excel to show a graph
> of this, can it be done?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks