Need help creating 3-month rolling averages...

Giganews Newsgroups
Subject: Need help creating 3-month rolling averages...
Posted by:  Chunklet (South164…@hotmail.com)
Date: 17 May 2006

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

Replies