Forum Discussion
How to smooth out a plot in excel to get a curve instead of scattered line
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 ima...
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.