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