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.
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 |