How to produce graph displaying a rolling quarterly average.

[ChubbyArse]

Hi,

I need to produce a graph which displays information in a quarterly rolling average.

I'll try and explain myself:

I have a dataset which is in this format:

Quarter-----Value
-----------------
Quarter 1---10000
Quarter 2---20000
Quarter 3---40000
Quarter 4---10000
Quarter 5---50000
Quarter 6---10000
Quarter 7---30000
Quarter 8---40000

I would like to produce a graph which displays this (Value on x, Quarter on y):

Quarter 1---10000 (Average of qtr 1)
Quarter 2---15000 (Average of qtr 1-2)
Quarter 3---23333 (Average of qtr 1-3)
Quarter 4---20000 (Average of qtr 1-4)
Quarter 5---30000 (Average of qtr 2-5)
Quarter 6---27500 (Average of qtr 3-6)
Quarter 7---25000 (Average of qtr 4-7)
Quarter 8---32500 (Average of qtr 5-8)

I'm not so much asking how do I make the graph, more how can I model my dataset to give the rolling average???

Thanks
Alex

 

[IdoMillet]

Crystal charts have a Trendline option (in CR 8.5 it's under Chart Analyzer) that provides many trendline setups, including a moving average.

Cheers,
- Ido

CUT, Visual CUT, and DataLink Viewer:
view, e-mail, export, burst, distribute, and schedule Crystal Reports.

http://www.MilletSoftware.com