Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Need help creating 3-month rolling averages...
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Need help creating 3-month rolling averages...
"Chunklet" skrev i en meddelelse
oups.com... 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. -- Best regards Leo Heuser Followup to newsgroup only please. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
rolling 12 month average | Excel Worksheet Functions | |||
Rolling up to the correct Month Dilemma | Excel Discussion (Misc queries) | |||
Formula for calculating a rolling 12 month average in excel? | Excel Discussion (Misc queries) | |||
How do I set up 12-month rolling month cells in excel? | Excel Discussion (Misc queries) | |||
3 month rolling chart | Charts and Charting in Excel |