Bar Chart not filling up correctly

**BLD65** · 01-11-2022, 03:50 PM

Thank you to all who respond.

The problem I can't seem to solve is with the Bar Charts not filling upward correctly. I will have one type at 100% but only goes up to 50% on the chart. I was expecting to see it at 100%.

See attached example.

Thanks!
BD

**MrShorty** · 01-11-2022, 03:59 PM

The Chart type is "100% stacked bar" -- which means that Excel will take the two data series, add them together, then fill each "stack" up to its percentage of the total. In the case of "technical videos", the first series has a value of 100%, the second series has a value of 100%, the total is 200%, the first series is 50% of the total, so it fills up to the 50% mark.

If I understand what you want, I think you want a formula in column E (the filler column) that subtracts column D from 100%. Try entering =1-D2 into E2 (copy/paste/fill down) and see if the chart is more in line with what you are expecting.