Grand Total on Pivot Chart Graph

Darmlucht

New Member
Joined
Nov 23, 2017
Messages
26
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!

1641562948505.png


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
ABCDEFGHIJKLMNOPQR
1
2
3Count of DateKolomlabelsAspect of productDeliveryPackagingSpecificationEindtotaal
4RijlabelsDeliveryForeign matterPackagingAspect of productSpecificationSaleslabelsApplicationEindtotaalP02 20201115
5P23115P03 202011
6P31214P04 20201114
7P411114P06 2020112
8P5213P07 20201
9P611114P08 202022
10P751219P10 202011
11P831329P11 2020112
12P9314P12 2020112
13P102215Eindtotaal337320
14P1112115
15P121113
16Eindtotaal22762718255
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
 

Excel Facts

Quick Sum
Select a range of cells. The total appears in bottom right of Excel screen. Right-click total to add Max, Min, Count, Average.

Forum statistics

Threads
1,223,355
Messages
6,171,615
Members
452,411
Latest member
sprichwort

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top