Forum Discussion
Trying to add moving average to scatterplot but the lines are showing up crazy
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?
2 Replies
Your data needs to be in chronological order in cell range.
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.
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?
