Side-by-Side Stacked Column Bar Chart?
Hi! I have two separate stacked column bar charts - one for 2023 and one for 2024. Both have the same two categories - webinars and onsites - and are comparing them week-over-week. Is there a way to place two stacked columns side-by-side?
Here's what it looks like:
Here's what I want it to look like:
Answers
-
You would create a column for each of the 4 and a fifth column for the week number. In the week number column, you would put each week number twice. In the first row of a week number, you would fill in only the '23 columns and in the second row for that same week number you would fill in only the '24 columns.
-
Hmmm... I'm not quite understanding. Here's what the source sheet looks like that the first chart is referencing:
But when I select Stacked Column Chart, it looks like this:
-
Right. So instead of having your Week column going
1
2
3
4
5
You would have
1
1
2
2
3
3
4
4
5
5
In the first "1" you would fill in the '23 columns and leave the '24 columns empty. Then in the second "1" you would fill in the '24 columns and leave the '23 columns empty.
-
That's amazing! It worked!!
One more question (maybe I'm just being greedy now): the horizonal labels show each date twice. Any way I can get it to show just once?
-
You could remove the label from alternating rows in the source data.
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.5K Get Help
- 424 Global Discussions
- 136 Industry Talk
- 465 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 145 Just for fun
- 62 Community Job Board
- 465 Show & Tell
- 32 Member Spotlight
- 1 SmartStories
- 301 Events
- 39 Webinars
- 7.3K Forum Archives