Excelling in Excel

By Natalie Streiner


In order to construct a graph of a function y=f(x) I simply followed a few basic steps.


I first input x in cell A1 and y in cell B2.

From there I input my x values.

I chose 1 to 29 as my domain.


From there, I then used the f(x) bar to input my function.

I chose to graph the  function y=4x+1.

Note that rather than typing “4x+1” in the f(x), A2 must be used for x as shown below.


Next, I highlighted the B2 to B30, so the function would be applied to those x values.


Then, I highlighted all the data, then clicked InsertąChartąScatterąSmooth Lined Function.

Here is the resulting graph of y=4x+1



I then followed these same steps in order to graph y=6x2






Back to Natalie’s Homepage