guruu math

Sheet1

	Qtr 1	Qtr 2	Qtr 3	Qtr 4	Yearly total
Yr1	23	14	56	78	171
Yr2	27	20	67	89	203
Yr3	34	30	73	83	220
Yr4	43	32	85	98	258
Yr5	50	36	101	123	310
Yr6	63	46	125	146	380

Product E

Qtr 1 Yr1 Yr2 Yr3 Yr4 Yr5 Yr6 23 27 34 43 50 63 Qtr 2 Yr1 Yr2 Yr3 Yr4 Yr5 Yr6 14 20 30 32 36 46 Qtr 3 Yr1 Yr2 Yr3 Yr4 Yr5 Yr6 56 67 73 85 101 125 Qtr 4 Yr1 Yr2 Yr3 Yr4 Yr5 Yr6 78 89 83 98 123 146 Yearly total Yr1 Yr2 Yr3 Yr4 Yr5 Yr6 171 203 220 258 310 380

Qtrs

From this graph, we can see that the 3rd and 4th quarter sales are much higher than the 1st and 2nd quarters. We can also see that sales increase every year through the Yearly Total line. If the yearly total was also displayed as a bar graph, it would have been very difficult to see quarterly information. However, it is easier to see by displaying quarterly sales as a bar and displaying yearly total and 1st quarter sales as a line graph.