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 |
Edit screen
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 |