Side-by-Side Stacked Column Bar Chart?

amy_ilearning

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:

Paul Newcome

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.

amy_ilearning

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:

Paul Newcome

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.

amy_ilearning

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?

Paul Newcome

You could remove the label from alternating rows in the source data.