<html> <head> <base href="https://bugs.documentfoundation.org/"> </head> <body> <div> <a class="bz_bug_link bz_status_UNCONFIRMED " title="UNCONFIRMED - CALC CHART Trend Lines for moving average not being "smoothed" similarly to Polynomial Trend Lines" href="https://bugs.documentfoundation.org/show_bug.cgi?id=139856#c6">Comment # 6</a> on <a class="bz_bug_link bz_status_UNCONFIRMED " title="UNCONFIRMED - CALC CHART Trend Lines for moving average not being "smoothed" similarly to Polynomial Trend Lines" href="https://bugs.documentfoundation.org/show_bug.cgi?id=139856">bug 139856</a> from <a class="email" href="mailto:that.man.colin@gmail.com" title="Colin <that.man.colin@gmail.com>"> Colin</a> <pre>(In reply to Louis Steinberg from <a href="show_bug.cgi?id=139856#c5">comment #5</a>) > Here is a workaround: Add a column D to your spreadsheet which calculates a > running average of column C and add it as to the plot separately as a > smoothed line. Hi Louis and thanks for your endeavours: I have already added columns for 3,7,10&14 event moving averages - 5664 "surplus" cells with a daily "growth" rate of +20 for the four new data elements. 400% overhead for smooth lines :(. As the columns are autofiltered and the charts can react to any filtering or sorting, that predicates quite an overhead when each new data element is appended and a new "snapshot" taken. It's almost as if one can see the cogs turning ;). Thanks again.</pre> </div> <hr> You are receiving this mail because: <ul> <li>You are the assignee for the bug.</li> </ul> </body> </html>