Very newb: sideways table / chart with column headings as y-axis, this is probably really obvious

[Weatsop]

I don't even know what words to search for. Apologies if this is obvious.

Here's a table:

Name	Region	Big	Mid	Little
Julie	North	13	5	12
Markus	North	16	18	12
Markus	South	12	6	21
Uma	North	13	9	1

What I'm trying to do is get a horizontal stacked bar chart, that has Big, Mid, and Little down the Y axis. Each of the 3 bars should be stacked from Jule's, Markus' and Uma's numbers. Note that from Markus I just want the one number (north and south combined).

I feel like I'm missing something very obvious, but I've spent a stupid amount of time going crazy.

[Weatsop]

Thank you so much! Turns out I had tried something like that.... a couple of hours ago... and didn't set the Legend. GAH!

You've saved me probably half a day of misery and shame. Thanks!

[FreemanZ · Accepted solution]

hi @Weatsop ,

the point is to first unpivot your data to something like below:

then everything becomes more intuitive:

About unpivot, please refer to the attachement or check here:

https://support.microsoft.com/en-us/office/unpivot-columns-power-query-0f7bad4b-9ea1-49c1-9d95-f5882...