In the coming Format Trendline dialog box check the Polynomial option. This technique could be wonderfully helpful if you get the data in a fixed format and you update charts by simply copy pasting the new data. Y b 6 x 6 b 2 x 2 b 1 x a.
Depending on the degree of your polynomial trendline use one of the following sets of formulas to get the constants.
The following chart will appear. STEP 1 Define Your Coordinates WHAT TO DOSet up your Excel spreadsheet to make a chart of points for and a graph of a linear equation. This technique could be wonderfully helpful if you get the data in a fixed format and you update charts by simply copy pasting the new data. Display trend line equation on the scatterplot.