Need help creating 3-month rolling averages...

[Chunklet]

I'm trying to create a graph with the rolling averages on excel based
on quarterly sales...
for example...

Q1 2004 = $1800
Q2 2004 = $2000
Q3 2004 = $2100
Q4 2004 = $1500
Q1 2005 = $3500
Q2 2005 = $3700
Q3 2005 = $2100
Q4 2005 = $3000

How would I enter the information into an equation and once that is
done how do i graph it to show the averages from quarter to quater.
Like Q1 04' to Q2 04 etc.
If anyone can help me with this I would be more then greatful for the
assistance.

Kreg

 

[Leo Heuser]

I'm trying to create a graph with the rolling averages on excel based
on quarterly sales...
for example...

Q1 2004 = $1800
Q2 2004 = $2000
Q3 2004 = $2100
Q4 2004 = $1500
Q1 2005 = $3500
Q2 2005 = $3700
Q3 2005 = $2100
Q4 2005 = $3000

How would I enter the information into an equation and once that is
done how do i graph it to show the averages from quarter to quater.
Like Q1 04' to Q2 04 etc.
If anyone can help me with this I would be more then greatful for the
assistance.

Kreg

Hi Kreg

One way.

Assuming headings in E2 and down and sales in F2 and down,
enter this formula in G2

=SUM($F$2:F2)/(ROW()-ROW($G$2)+1)

Copy the formula down from G2.

Use column E and G for your chart.