Trying to add moving average to scatterplot but the lines are showing up crazy

Copper Contributor

Trying to add a moving average line to the lowest daily stock price data. There are 1259 data points. When I enter it, it looks like this picture. What am I doing wrong? Excel Phot.PNG

2 Replies

@Clobianco 

Could you attach a small sample workbook demonstrating the problem (without sensitive data), or if that is not possible, make it available through OneDrive, Google Drive, Dropbox or similar?

@Clobianco 

 

Your data needs to be in chronological order in cell range.

 

JoeUser_0-1701129273399.png

 

The blue line is the data.  The red line is a moving average trendline.

 

Even though the random data is plotted in chronological order, the "dots" are connected in the order that the data appears in the cell range.