How to display equation on chart in excel on mac

 

A common question new users ask is "How can I plot an equation?" I think people expect that charts have a magical ability to accept an equation and spit out a graph of X vs.

Y. Excel charts aren't that smart, though: they can only plot data values that you assign. To provide this data you need to enter X values into one column (or row), and calculate the corresponding Y values in the next column (or row).

Then select this data and create an XY chart to show the relationship.

Plot an Equation Using Worksheet Data

Suppose for example you wanted to plot the relationship between the Fahrenheit and Celsius temperature scales.

Enter descriptive headers into cells A1 and B1. Enter X values of interest into A2 through A5. Enter the following formula into cell B2, then copy the cell (Ctrl+C), select B3:B5, and paste (Ctrl+V).

=(A2-32)*5/9

For this simple linear relationship, all that you really need are the lowest and highest X values of interest.

And it's not necessary to use markers for the individual data points, unless you want to us

how to plot quadratic equation in excel

how to plot regression equation in excel