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).
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.
