Stacked 100% bar chart not adding up to 100%

[joakim1024]

Hi,

I created a 100% stacked column chart but for some reason two of the entries does not add upp to 100% ???

There are no filters active, and i also cretead a pie chart filtered on only that entry to check.

In the stacked 100% the result is 20% & 71% and in the pie chart the result is 22% & 78%.

Also checked for empty rows in the data.

I can't figure out why this is happening.

[joakim1024 · Accepted solution]

Solved it.

I had formatted the chart to start at zero (used it for regular chart before) and there was negative result for a specific category. Although you would expect it to show the same result as a pie chart.... (which obviously disregards the negative category).