I have a column chart with daily production and consumption data. I'd like to add trend lines for each taking the average of the ten days prior to each point.
I'm sure it's easy, but I don't see in the trendline configuration options how to set the average and number of points to average.
Any direction would be greatly appreciated.