Change Y Axis Value

[Cobalt58_9]

Hi gang, maybe it's because it's late, or maybe it's because I've gotten too many notes back, but does anyone know how to change the y-axis value on a Stacked Column Chart? I want it to look like this: 

Instead it's giving me the thousands count on the left rather than the two numbers equalling 100%.

Thanks, and feel free to insult me for this.

[v-yilong-msft]

Hi @Cobalt58_9 ,

Your solution is great, @vicky_ . It worked like a charm! Here I have another idea in mind, and I would like to share it for reference.

I create a visual as you mentioned.

You can also open the Data labels and Value. It will show you what you want.

Best Regards

Yilong Zhou

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[vicky_ · Accepted solution]

You can use the 100% stacked column chart and slap on some data labels for the actual amount

[Cobalt58_9]

Good grief, that did the trick. Thank you so much.