Stacked bar chart as an image more that 84%!

Hi all,

I'm new to the group. I've used Excel for over 30 years, but I am lost!

I'm doing a stacked bar chart for my PhD with two people as the stacked bar chart. It's great for visualisation, but when I change the percentage above 84% on the second image, it falls over. I'm wondering if there is a quick way to solve it that I haven't found. Below are two diagrams. The first is what I want It to look like with lower values, and the second is what happens when I increase the value. I feel like I'm going mad!

people bar 1.png

people bar 2.png

Thank you for any help you can give me.

Alison