Help with graphs

[ozbroady]

Hi..

Im hoping someone can help me with some help building a graph.

I have a spreadsheet which I have simplified down to two columns, one is date, and the other is a number between 1 and 10.

The number between 1-10 signifies a category of a particular event that happened that day. Some dates have more than one event.

I would like to graph the total number of occurrences of each category over a monthly period.

So, maybe a line graph with 10 lines, and then the amount of instances for that month on the Y axis or something like that? I would also settle for 10 individual graphs if that was my only option. I am somewhat a novice when it comes to excel - I would really appreciate if someone could help me.

A sample of the data is as follows.

Thanks.

DATE	EVENT CATEGORY
25/04/15	2
25/04/15	1
25/04/15	4
25/04/15	2
25/04/15	1
27/04/15	1
27/04/15	4
28/04/15	5
29/04/15	1
30/04/15	2
30/04/15	1
1/05/15	5
1/05/15	5
1/05/15	5
1/05/15	5
1/05/15	10
2/05/15	7
2/05/15	4
3/05/15	2
5/05/15	5
6/05/15	7
7/05/15	5
7/05/15	1
9/05/15	3
10/05/15	1
12/05/15	7
12/05/15	2
12/05/15	1
13/05/15	1
14/05/15	1
15/05/15	7
16/05/15	1
16/05/15	1
17/05/15	1
17/05/15	7
17/05/15	1
17/05/15	2
18/05/15	5
18/05/15	5
18/05/15	5
18/05/15	3
18/05/15	1
20/05/15	1
20/05/15	1
21/05/15	7
21/05/15	4
22/05/15	2
22/05/15	1
25/05/15	4
25/05/15	7
25/05/15	7
25/05/15	3
26/05/15	5
26/05/15	3
27/05/15	5
28/05/15	1
29/05/15	7
30/05/15	5
30/05/15	1
1/06/15	1
1/06/15	10
1/06/15	4
1/06/15	7
2/06/15	5
2/06/15	10
2/06/15	2
2/06/15	5
2/06/15	4
2/06/15	1
3/06/15	1
3/06/15	1
5/06/15	7
5/06/15	1
5/06/15	1
5/06/15	5
6/06/15	8
6/06/15	6
7/06/15	1
7/06/15	1
8/06/15	1
8/06/15	4
9/06/15	7
10/06/15	4
10/06/15	1
11/06/15	2
12/06/15	2
13/06/15	7
13/06/15	1
13/06/15	4
14/06/15	7
15/06/15	1
16/06/15	1
16/06/15	1
16/06/15	3
16/06/15	1
16/06/15	5
17/06/15	7
17/06/15	7
17/06/15	2
18/06/15	10
18/06/15	8
18/06/15	5
19/06/15	5
19/06/15	1
19/06/15	6
19/06/15	7
20/06/15	6
22/06/15	6
22/06/15	7
25/06/15	10
26/06/15	2
27/06/15	1
27/06/15	1
27/06/15	4
27/06/15	4
28/06/15	7
29/06/15	7
30/06/15	1
30/06/15	1
30/06/15	1
30/06/15	1
1/07/15	5
2/07/15	10
2/07/15	6
2/07/15	1
3/07/15	1
5/07/15	5
5/07/15	1
5/07/15	1
6/07/15	1
7/07/15	1
8/07/15	1
9/07/15	1
9/07/15	1
9/07/15	7
10/07/15	3
10/07/15	1
10/07/15	9
10/07/15	8
11/07/15	3
11/07/15	10
12/07/15	7
12/07/15	5
12/07/15	5
12/07/15	1
12/07/15	3
13/07/15	3
13/07/15	1
13/07/15	7
14/07/15	1
14/07/15	3
14/07/15	5
14/07/15	2
15/07/15	7
15/07/15	1
15/07/15	5

[hossat]

Hi,

It simple by using PivotTable.
Into your PT group the dates by month than count the number of each category.
See attached file

Good luck
ForOzbroady.xlsx