How to Graph a Function in Excel. A mathematical function is a formula that takes an input, x, applies a set of calculations to it, and produces an output called y.

Open a new Excel spreadsheet. Click cell A1 and type "Data Set" into the cell. Click cell A2 and type in the first value for the data set that you want to make into a percentile graph.