Chart of Moving Average

[CAPiTA]

I am trying to create a chart that would display a moving average of my data. The fields look like this:

Parts.PartID Parts.Offset
001 0.521
002 0.545
003 0.567
004 0.509
005 0.523
...

I am a bit stumped about how to set this up. I would like to average every 10 data values and display them in a bar chart. Any help is much appreciated.

 

[CAPiTA]

Also, I'm using Crystal Reports version 8.

 

[CAPiTA]

bump