Helle dear Excel-geniuses,
I once again need your kind help. I don't think this is a hard one, but I've been staring at it and looking far and wide to find the solution to my problem.
I made this Pivot table and accompagning pivot-chart/graph.
It is divided in days and instances per category.
Now I want to add, as a final 'bar' in the graph, the total amount of instances, but divided in their specific category.
The categories have a color. So the bar should be showing the total amount of instances, and then the bar is divided into the different colors.
I will add the sheet with the pivot table data and a picture of the graph as it is now.
I hope this will work, because I cannot share the data, since it's a bit sensitive.
If it is necessary to provide an answer, please let me know!
So what I need is a final bar, next to P12, that combines all the different colors of all the P's. So Delivery will be 22 'high' in Blue, Orange will be 7 high.. I hope you get the jist.
Thank you very much for looking at it, and thank you even more if you have a solution.
Love u guys! NEver been let down here before, so looking to keep that streak going!
Kind regards,
I once again need your kind help. I don't think this is a hard one, but I've been staring at it and looking far and wide to find the solution to my problem.
I made this Pivot table and accompagning pivot-chart/graph.
It is divided in days and instances per category.
Now I want to add, as a final 'bar' in the graph, the total amount of instances, but divided in their specific category.
The categories have a color. So the bar should be showing the total amount of instances, and then the bar is divided into the different colors.
I will add the sheet with the pivot table data and a picture of the graph as it is now.
I hope this will work, because I cannot share the data, since it's a bit sensitive.
If it is necessary to provide an answer, please let me know!
So what I need is a final bar, next to P12, that combines all the different colors of all the P's. So Delivery will be 22 'high' in Blue, Orange will be 7 high.. I hope you get the jist.
Thank you very much for looking at it, and thank you even more if you have a solution.
Love u guys! NEver been let down here before, so looking to keep that streak going!
Kind regards,
TotalStackedPivotChart.xlsx | ||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
A | B | C | D | E | F | G | H | I | J | K | L | M | N | O | P | Q | R | |||
1 | ||||||||||||||||||||
2 | ||||||||||||||||||||
3 | Count of Date | Kolomlabels | Aspect of product | Delivery | Packaging | Specification | Eindtotaal | |||||||||||||
4 | Rijlabels | Delivery | Foreign matter | Packaging | Aspect of product | Specification | Sales | labels | Application | Eindtotaal | P02 2020 | 1 | 1 | 1 | 5 | |||||
5 | P2 | 3 | 1 | 1 | 5 | P03 2020 | 1 | 1 | ||||||||||||
6 | P3 | 1 | 2 | 1 | 4 | P04 2020 | 1 | 1 | 1 | 4 | ||||||||||
7 | P4 | 1 | 1 | 1 | 1 | 4 | P06 2020 | 1 | 1 | 2 | ||||||||||
8 | P5 | 2 | 1 | 3 | P07 2020 | 1 | ||||||||||||||
9 | P6 | 1 | 1 | 1 | 1 | 4 | P08 2020 | 2 | 2 | |||||||||||
10 | P7 | 5 | 1 | 2 | 1 | 9 | P10 2020 | 1 | 1 | |||||||||||
11 | P8 | 3 | 1 | 3 | 2 | 9 | P11 2020 | 1 | 1 | 2 | ||||||||||
12 | P9 | 3 | 1 | 4 | P12 2020 | 1 | 1 | 2 | ||||||||||||
13 | P10 | 2 | 2 | 1 | 5 | Eindtotaal | 3 | 3 | 7 | 3 | 20 | |||||||||
14 | P11 | 1 | 2 | 1 | 1 | 5 | ||||||||||||||
15 | P12 | 1 | 1 | 1 | 3 | |||||||||||||||
16 | Eindtotaal | 22 | 7 | 6 | 2 | 7 | 1 | 8 | 2 | 55 | ||||||||||
17 | ||||||||||||||||||||
18 | ||||||||||||||||||||
19 | ||||||||||||||||||||
20 | ||||||||||||||||||||
21 | ||||||||||||||||||||
22 | ||||||||||||||||||||
23 | ||||||||||||||||||||
24 | ||||||||||||||||||||
25 | ||||||||||||||||||||
26 | ||||||||||||||||||||
27 | ||||||||||||||||||||
28 | ||||||||||||||||||||
29 | ||||||||||||||||||||
30 | ||||||||||||||||||||
31 | ||||||||||||||||||||
32 | ||||||||||||||||||||
33 | ||||||||||||||||||||
34 | ||||||||||||||||||||
35 | ||||||||||||||||||||
36 | ||||||||||||||||||||
37 | ||||||||||||||||||||
38 | ||||||||||||||||||||
39 | ||||||||||||||||||||
40 | ||||||||||||||||||||
41 | ||||||||||||||||||||
42 | ||||||||||||||||||||
43 | ||||||||||||||||||||
44 | ||||||||||||||||||||
45 | ||||||||||||||||||||
Graphs |