How To Curve Fitting In Excel. Excel charts are a convenient way to fit a curve to experimental data. Check the option for “display equation on chart”.

Select the original experiment data in excel, and then click the scatter > scatter on the insert tab. Also shown is the use of excel's solver to find optimal model paramet. Excel will instantly add the best fit curve for our data, and display the polynomial equation on the chart.