close

I am trying to set up a graph in MS Excel where you can enter in the values
for X and B and it will graph the line, like a graphing caluclator would. Is
that possible?

Excel graphs points, not equations. For a straight line, you would only
need to calculate the first and last points on the line and plot them as
an quot;XY (Scatter)quot; chart with points connected by a line. Alternately,
Tushar Mehta has written an add-in for plotting functions
www.tushar-mehta.com/excel/so...ger/index.html

Jerry

Adam wrote:

gt; I am trying to set up a graph in MS Excel where you can enter in the values
gt; for X and B and it will graph the line, like a graphing caluclator would. Is
gt; that possible?If the relationship is not necessarily linear, and you just want to hack out
a series without using an add-in, you can simply put a set of X values into
one column, then in the next column insert formulas that calculate the
appropriate Y values. Then make the plot with these two columns.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
PeltierTech.com/
_______quot;Jerry W. Lewisquot; gt; wrote in message
...
gt; Excel graphs points, not equations. For a straight line, you would only
gt; need to calculate the first and last points on the line and plot them as
gt; an quot;XY (Scatter)quot; chart with points connected by a line. Alternately,
gt; Tushar Mehta has written an add-in for plotting functions
gt; www.tushar-mehta.com/excel/so...ger/index.html
gt;
gt; Jerry
gt;
gt; Adam wrote:
gt;
gt;gt; I am trying to set up a graph in MS Excel where you can enter in the
gt;gt; values for X and B and it will graph the line, like a graphing caluclator
gt;gt; would. Is that possible?
gt;

arrow
arrow
    全站熱搜
    創作者介紹
    創作者 software 的頭像
    software

    software

    software 發表在 痞客邦 留言(0) 人氣()