How to Graph a Function in Excel. ... which you'll use to plot the function. For example, if your intervals are whole numbers, you might start by entering "1" into cell A2 and "2" into cell A3.