Show multiple trendlines on a Numbers chart
I would like to show both a moving average and linear trendlines on the same chart. How do I do that?
iMac 24″, macOS 14.0
Question marked as
Suggestion 1:
plot the moving average from a additional column:
Suggestion 2:
Duplicate the data column and make the dots and connecting lines invisible, then plot the moving average for the series:
Only issue I found with this is that one series lays exactly on top of the other. So you must change a data point in the second trend so you can select the series in order to modify the selection for trendline. Once you have changed the trendline selection, restore the original data on the second column (the "repeated" column)