| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
quarterly totals
How would i write the formula for entering 4 separte quarterly totals into a
bar graph. Thanks |
|
#2
|
|||
|
|||
|
Devko,
Assume the months are in A1:A6 and the data is in B1:B6. Jan 5 Feb 3 Mar 6 Apr 4 May 2 Jun 5 The formula for quarter 1 is =AVERAGE(B1:B3) The formula for quarter 2 is =AVERAGE(B4:B6) Quarters 3 and 4 follow the same logic. ---- Regards, John Mansfield http://www.pdbook.com "Davko" wrote: How would i write the formula for entering 4 separte quarterly totals into a bar graph. Thanks |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Pivot Table Totals | New Users to Excel | |||
| Totals For a Pivot Table?? | Excel Discussion (Misc queries) | |||
| Pivot Table Grand Totals | Excel Worksheet Functions | |||
| List employees with hours worked, weekly, quarterly, and annually | New Users to Excel | |||
| How do I show summary totals from a pivot table on a bar chart | Charts and Charting in Excel | |||
Linear Mode
