on Line Chart... can you add a reference line that is an AVERAGE?
I didn't see any averaging formula in the pulldown for reference lines.
It would be cool to do something like this: average($VALUE$,20) as an example. Where 20 would be the number of prior values to average.