G Guest Apr 24, 2005 #1 How would i write the formula for entering 4 separte quarterly totals into a bar graph. Thanks
G Guest Apr 26, 2005 #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.
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.
