Lobsterboy1
Board Regular
- Joined
- Aug 5, 2016
- Messages
- 90
I dont really know much about excel charts but have been asked to come up with a column chart from some data I have been given. The data looks like this
Date Shift Area No Code
6/9/17 John A 5 21
6/9/17 John A 10 17
6/9/17 John B 11 6
6/9/17 John B 4 9
6/9/17 John C 11 15
6/9/17 John C 9 19
6/9/17 John C 5 5
6/9/17 John C 10 7
6/9/17 Dave A 6 21
6/9/17 Dave A 1 17
6/9/17 Dave A 19 6
6/9/17 Dave B 6 9
6/9/17 Dave B 21 15
6/9/17 Dave C 19 19
6/9/17 Dave C 15 5
6/9/17 Dave C 10 7
7/9/17 John A 8 21
7/9/17 John A 15 17
7/9/17 John A 14 6
7/9/17 John B 9 9
7/9/17 John B 15 15
7/9/17 John B 8 19
7/9/17 John C 6 5
7/9/17 John C 19 7
7/9/17 Dave A 6 21
7/9/17 Dave A 1 17
7/9/17 Dave A 19 6
7/9/17 Dave B 6 9
7/9/17 Dave B 21 15
7/9/17 Dave C 19 19
7/9/17 Dave C 15 5
7/9/17 Dave C 10 7
Sorry for not using one of the add ins but I have a new pc at work and symantec is blocking excel Jenie download.
The chart they want is I think a stacked column chart. I am wanting the No value up the left hand side, this is the amount of units. Then along the bottom the area first then inside each area the code, then above each code a column with the total amount splint into two colours for each shift if that makes sense.
something like this.
100
75
50
25
0
21 17 6 6 9 15 19 15 19 5 7
| A | B | C |
So above the 21 in the A section there would be a column that is 25 high overall but split into 2 colours. 1st 13 high for John then the rest another colour for Dave. The date does not matter at this point but there might be other shifts added so then the column would need 3 or 4 colours split over the overall amount.
Is this possible?
I can change the layout of the data if needed.
The layout keeps changing the formatting when I try to post the 21,17 and 6 would be above the A, the 6,9,15 and 19 above the B and the rest above the C.
Thanks for any help.
Date Shift Area No Code
6/9/17 John A 5 21
6/9/17 John A 10 17
6/9/17 John B 11 6
6/9/17 John B 4 9
6/9/17 John C 11 15
6/9/17 John C 9 19
6/9/17 John C 5 5
6/9/17 John C 10 7
6/9/17 Dave A 6 21
6/9/17 Dave A 1 17
6/9/17 Dave A 19 6
6/9/17 Dave B 6 9
6/9/17 Dave B 21 15
6/9/17 Dave C 19 19
6/9/17 Dave C 15 5
6/9/17 Dave C 10 7
7/9/17 John A 8 21
7/9/17 John A 15 17
7/9/17 John A 14 6
7/9/17 John B 9 9
7/9/17 John B 15 15
7/9/17 John B 8 19
7/9/17 John C 6 5
7/9/17 John C 19 7
7/9/17 Dave A 6 21
7/9/17 Dave A 1 17
7/9/17 Dave A 19 6
7/9/17 Dave B 6 9
7/9/17 Dave B 21 15
7/9/17 Dave C 19 19
7/9/17 Dave C 15 5
7/9/17 Dave C 10 7
Sorry for not using one of the add ins but I have a new pc at work and symantec is blocking excel Jenie download.
The chart they want is I think a stacked column chart. I am wanting the No value up the left hand side, this is the amount of units. Then along the bottom the area first then inside each area the code, then above each code a column with the total amount splint into two colours for each shift if that makes sense.
something like this.
100
75
50
25
0
21 17 6 6 9 15 19 15 19 5 7
| A | B | C |
So above the 21 in the A section there would be a column that is 25 high overall but split into 2 colours. 1st 13 high for John then the rest another colour for Dave. The date does not matter at this point but there might be other shifts added so then the column would need 3 or 4 colours split over the overall amount.
Is this possible?
I can change the layout of the data if needed.
The layout keeps changing the formatting when I try to post the 21,17 and 6 would be above the A, the 6,9,15 and 19 above the B and the rest above the C.
Thanks for any help.
