| 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 |
| 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 | |||
Threaded Mode
