Next we calculate a new series in Excel using the equation above. Cell References and Arrays in the SERIES Formula. One of the most powerful features in Excel is the ability to calculate numerical information using formulasJust like a calculator Excel can add subtract multiply and divide.
Plotting the original y-data and the calculated result ycalc on the same graph tells us that the parameters of the function are not yet.
To add an axis label click on any blank part of your graph. The x-axis is represented by a linear. Section 14 Graphing functions with Excel. How to add a trendline in Excel.