example: 3-points moving average and standard chart macro
Yellow cells are calculated ones by Calc macro.
Must be 'Freeze mode' like this( ).
Period | data | 3-points moving average |
---|---|---|
1 | 2 | 2 |
2 | 4 | 3 |
3 | 9 |
5 |
4 | 3 | 5.3 |
5 | 8 |
6.7 |
6 | 2 |
4.3 |
Yellow cells are calculated ones by Calc macro.
Must be 'Freeze mode' like this( ).
Period | data | 3-points moving average |
---|---|---|
1 | 2 | 2 |
2 | 4 | 3 |
3 | 9 |
5 |
4 | 3 | 5.3 |
5 | 8 |
6.7 |
6 | 2 |
4.3 |