Hi everyone,
I know there has been already a huge amount of posts on this issue but I have managed to make the divergent stacked bar on Sheet 28.
The only problem is that my 0% is not in the center of the blue bar which is the center of the response Neutral (= "Noch eens noch oneens").
I hope the following image makes clear what the problem is.
The red line at 0% should be in the middle of the blue bar which is clearly not the case.
Eveline,
It looks like you set everything up properly, but I think there is something going on with
the data or the filters:
I'm not sure why, but it looks like things were getting thrown off because
[Score] was coming back as Null for the two "Enigszins..." Pivot Field Values.
Just to check, when I forced them to have a score, it lined up properly.
Please see screenshot below and workbook v18.1 attached in the Forum Thread.
