| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to link trendline equation in graph to cell? | Excel Discussion (Misc queries) | |||
| Problem with Equation Display | Excel Discussion (Misc queries) | |||
| How to plot a graph from an equation | Excel Discussion (Misc queries) | |||
| How do I create a graph from an equation and not a set of data? | Charts and Charting in Excel | |||
| how do I graph a linear equation? | Charts and Charting in Excel | |||
Linear Mode
