Hi All,
I want to create a bar chart or graph based on how many times a colour appears in column B based on the start and end date of a month. This would be added to on a monthly basis.
Do I start from the 1st Jan to 31 Dec and have zero's for all the months to come.
I want to count how many times the 3 colours in colomn B based on the 1st March to 31st March. But I will need this to be able to update as the year goes on as more date is added.
Any help would be appreciated.
I want to create a bar chart or graph based on how many times a colour appears in column B based on the start and end date of a month. This would be added to on a monthly basis.
Do I start from the 1st Jan to 31 Dec and have zero's for all the months to come.
Excel Workbook | ||||
---|---|---|---|---|
A | B | |||
1 | Date | Department | ||
2 | 25/02/2011 | Blue | ||
3 | 26/02/2011 | Blue | ||
4 | 27/02/2011 | Blue | ||
5 | 28/02/2011 | Blue | ||
6 | 01/03/2011 | Blue | ||
7 | 02/03/2011 | Blue | ||
8 | 03/03/2011 | Blue | ||
9 | 04/03/2011 | Blue | ||
10 | 05/03/2011 | Blue | ||
11 | 06/03/2011 | Blue | ||
12 | 07/03/2011 | Blue | ||
13 | 08/03/2011 | Blue | ||
14 | 09/03/2011 | Blue | ||
15 | 10/03/2011 | Blue | ||
16 | 11/03/2011 | Blue | ||
17 | 12/03/2011 | Blue | ||
18 | 13/03/2011 | Blue | ||
19 | 14/03/2011 | Pink | ||
20 | 15/03/2011 | Pink | ||
21 | 16/03/2011 | Pink | ||
22 | 17/03/2011 | Pink | ||
23 | 18/03/2011 | Pink | ||
24 | 19/03/2011 | Pink | ||
25 | 20/03/2011 | Pink | ||
26 | 21/03/2011 | Pink | ||
27 | 22/03/2011 | Yellow | ||
28 | 23/03/2011 | Yellow | ||
29 | 24/03/2011 | Yellow | ||
30 | 25/03/2011 | Yellow | ||
31 | 26/03/2011 | Yellow | ||
32 | 27/03/2011 | Yellow | ||
33 | 28/03/2011 | Yellow | ||
34 | 29/03/2011 | Pink | ||
35 | 30/03/2011 | Blue | ||
36 | 31/03/2011 | Blue | ||
37 | 01/04/2011 | Blue | ||
38 | 02/04/2011 | Blue | ||
39 | 03/04/2011 | Yellow | ||
40 | 04/04/2011 | Pink | ||
41 | 05/04/2011 | Pink | ||
42 | 06/04/2011 | Pink | ||
43 | 07/04/2011 | Pink | ||
44 | 08/04/2011 | Pink | ||
45 | 09/04/2011 | Pink | ||
46 | 10/04/2011 | Pink | ||
47 | 11/04/2011 | Pink | ||
48 | 12/04/2011 | Pink | ||
49 | 13/04/2011 | Pink | ||
50 | 14/04/2011 | Yellow | ||
51 | 15/04/2011 | Yellow | ||
52 | 16/04/2011 | Yellow | ||
53 | 17/04/2011 | Yellow | ||
54 | 18/04/2011 | Yellow | ||
55 | 19/04/2011 | Yellow | ||
56 | 20/04/2011 | Yellow | ||
57 | 21/04/2011 | Yellow | ||
58 | 22/04/2011 | Yellow | ||
Sheet1 |
I want to count how many times the 3 colours in colomn B based on the 1st March to 31st March. But I will need this to be able to update as the year goes on as more date is added.
Any help would be appreciated.