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