- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Very newb: sideways table / chart with column headings as y-axis, this is probably really obvious
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.
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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:
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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!
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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:

Helpful resources
Subject | Author | Posted | |
---|---|---|---|
Anonymous
| 06-24-2020 12:35 AM | ||
08-09-2024 08:52 AM | |||
12-05-2023 05:32 PM | |||
11-04-2022 10:45 AM | |||
12-02-2021 11:54 AM |
User | Count |
---|---|
132 | |
105 | |
85 | |
55 | |
46 |