How to smooth out a plot in excel to get a curve instead of scattered line

New Contributor


So I have a lot of data (around 3k) now as I plot the line graph i get this scattered thing in blue. Tried smoothing the curve but it makes it worst. I need to plot it in a way as is in 2nd image here with yellow color (I have drawn it with my hand but I need some way in which excel can best fit the curve in one smooth line). 


1 Reply


Click anywhere in the chart.

On the Chart Design tab of the ribbon, click Add Chart Element > Trendline > More Trendline Options...

Select Moving Average, then set the Period to (for example) 100.

Play with the value of Period to see if you get something you like.Chart.png