Moving Average?

Captain Kirk · Guest

Is there any way to put a moving average on a chart in the Doze version Calc? I've checked the help file, but found no mention of moving averages.

dfrench · Posted: Fri Nov 14, 2003 12:32 am Post subject:

No, I don't think so (not like the opposition Sad

). Simple to add a column of formulas that calculate the average over the preceding 2,3,4...elements, though.
You could logon to the OOo project that is working on improving charts and suggest the enhancement.

SergeM · Posted: Fri Nov 14, 2003 10:35 am Post subject:

I don't know automatic way, but effectivly there is no problem when you add a column where you calculate the moving average with the classicals formulas of average... This column is not the same length of the first of course but the missing values don't appear in the graph.
_________________
Linux & Windows OOo3.0
UNO & C++ : WIKI
http://wiki.services.openoffice.org/wiki/Using_Cpp_with_the_OOo_SDK
In French
http://wiki.services.openoffice.org/wiki/Documentation/FR/Cpp_Guide