Does anyone know how to make Excel spreadsheet graph this limit f = 1/x?

Answer 1

Sure. I guess there will be easier ways to do it, but this is *a* way.

Put in column A the numbers 1 to 100 say.
Put in column B the formula "=1/A1" and drag it down so that in each cell it is dividing 1 by the number to the left in column A.
Select column B for your chart wizard and that ought to do it.

Answer 2

Another way to play around with the graph is to set a number, say .1 in cell a1

Next, in cell b1, put =a1
in cells b2 put =$a$1+b1, then copy it for 98 more cells below

Then, in cell c1, put =1/b1 and copy it for 99 more cells.

Then graph the function using a line graph. You may have to tell the graph that the series in b1:b100 is the values for x. Just select the series tab and make the adjustment while you create the graph.

Then you can play around with the number in a1 to see how it affects the graph