Question

How do I plot a series graph with this data provided?

Month	1987	1988	1989	1990	1991	1992	1993	1994	1995	1996
Jan	95	104	101	88	132	125	111	127	119	147
Feb	94	100	96	110	109	118	123	129	147	146
Mar	98	99	82	129	101	121	121	132	164	133
Apr	96	88	84	113	111	140	139	108	135	148
May	95	89	85	114	140	141	119	115	124	141
Jun	115	108	124	169	179	201	156	149	168	191
Jul	107	109	134	131	145	152	154	155	159	178
Aug	104	101	109	139	140	138	136	129	137	156
Sep	96	106	121	120	120	137	105	117	149	119
Oct	112	102	111	115	129	138	132	166	159	138
Nov	98	78	101	116	118	144	123	152	175	175
Dec	102	111	112	128	139	148	164	173	195	188

Answer 1

Answer:

The series graph can be prepared as below

Steps:

• Go to excel
• Make the list of the data as given in the question
• Select the data in excel sheet
• Select the graph options in excel insert menu.
• Select the series option of graph and click OK
• The below series graph will be made as below

* 1987 +1988 + 1989 *1990 *1991 -1992 EXCH KK +1993 1994 1995 1996 Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec