Graph an Equation in Excel 2007

[Michael Danielson]

I am trying to graph an equation in Excel 2007.

There are a couple of examples using named ranges that I have tried from the internet that don't seem to work. They both were "programmed" in Excel 4 so it may be related to the difference between these two versions.

1 simple equation I am trying to graph is y=(4.18T)-(760/t). I would like to be able to change the starting x value and ending x value as well as the number of data points to graph.

(This is easy to do on a graphing calculator so I would think that Excel could do it)

Thanks,
Mike

 

[NdNoviceHlp]

Almost 20 thousand views and no easy answer. HTH. Dave
http://www.mrexcel.com/forum/showthread.php?t=536821

 

[Rasm]

You could create an array with your calculated values - this link shows how to use arrays to populate a chart


http://www.excelfox.com/forum/showthread.php?14-Making-a-Histogram-Chart-Using-Arrays