How to Graph a Function in Excel. A mathematical function is a formula that takes an input, x, ... For example, you can plot profit minus costs at various levels of sales, ...