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

%3CLINGO-SUB%20id%3D%22lingo-sub-3340418%22%20slang%3D%22en-US%22%3EHow%20to%20smooth%20out%20a%20plot%20in%20excel%20to%20get%20a%20curve%20instead%20of%20scattered%20line%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3340418%22%20slang%3D%22en-US%22%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%2216520445735064549624570810192644.jpg%22%20style%3D%22width%3A%202992px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F370068iA8F512EFF499FD52%2Fimage-size%2Fmedium%3Fv%3Dv2%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%2216520445735064549624570810192644.jpg%22%20alt%3D%2216520445735064549624570810192644.jpg%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3ESo%20I%20have%20a%20lot%20of%20data%20(around%203k)%20now%20as%20I%20plot%20the%20line%20graph%20i%20get%20this%20scattered%20thing%20in%20blue.%20Tried%20smoothing%20the%20curve%20but%20it%20makes%20it%20worst.%20I%20need%20to%20plot%20it%20in%20a%20way%20as%20is%20in%202nd%20image%20here%20with%20yellow%20color%20(I%20have%20drawn%20it%20with%20my%20hand%20but%20I%20need%20some%20way%20in%20which%20excel%20can%20best%20fit%20the%20curve%20in%20one%20smooth%20line).%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%2216520447942719062805925887993739.jpg%22%20style%3D%22width%3A%202992px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F370069i913C076CC4208C86%2Fimage-size%2Fmedium%3Fv%3Dv2%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%2216520447942719062805925887993739.jpg%22%20alt%3D%2216520447942719062805925887993739.jpg%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-3340418%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3340459%22%20slang%3D%22en-US%22%3ERe%3A%20How%20to%20smooth%20out%20a%20plot%20in%20excel%20to%20get%20a%20curve%20instead%20of%20scattered%20line%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3340459%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1167084%22%20target%3D%22_blank%22%3E%40Ps18priyanka%3C%2FA%3E%3C%2FP%3E%0A%3CP%3EClick%20anywhere%20in%20the%20chart.%3C%2FP%3E%0A%3CP%3EOn%20the%20Chart%20Design%20tab%20of%20the%20ribbon%2C%20click%20Add%20Chart%20Element%20%26gt%3B%20Trendline%20%26gt%3B%20More%20Trendline%20Options...%3C%2FP%3E%0A%3CP%3ESelect%20Moving%20Average%2C%20then%20set%20the%20Period%20to%20(for%20example)%20100.%3C%2FP%3E%0A%3CP%3EPlay%20with%20the%20value%20of%20Period%20to%20see%20if%20you%20get%20something%20you%20like.%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Chart.png%22%20style%3D%22width%3A%20723px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F370073iA951FC9C0F12B5D5%2Fimage-size%2Flarge%3Fv%3Dv2%26amp%3Bpx%3D999%22%20role%3D%22button%22%20title%3D%22Chart.png%22%20alt%3D%22Chart.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

16520445735064549624570810192644.jpg

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

16520447942719062805925887993739.jpg

1 Reply

@Ps18priyanka

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