I have this equation y = 45.67 + 2.38X and would like excel to show a graph of this, can it be done?
P pokdbz Jan 12, 2006 #1 I have this equation y = 45.67 + 2.38X and would like excel to show a graph of this, can it be done?
B Bernie Deitrick Jan 12, 2006 #2 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
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
