2 Sets of Data - Stacked Chart in 365

[phillygirl777]

Hello,

Here is the simplified version of a chart that I have to create in Excel. There is a sales chart that shows breakdown for 2020 by region, stacked by product type. Now I need to add a column for 2019 for each region, broken down in the same fashion (by product). I highlighted the columns that I need to add. For some reason I get stacked columns with 4 categories instead of 2. I tried adding $E$1:$F$5 and got an error message.

Any suggestions?

Thank you!

 

[phillygirl777]

Forgot to mention - I am not supposed to use macros or VB script as it will be on the shared drive

 

[mikenz]

is this the chart you are looking for? This is using the chart type 3-d Clustered Column.

 

[phillygirl777]

is this the chart you are looking for? This is using the chart type 3-d Clustered Column.
View attachment 64887

Thanks for your input, but I am looking for adjacent stacked columns, 2 per region, split between 2 different product types

 

[GraH - Guido]

Looking for something like this?

It requires your data to be organized a bit differently. Have a look at Peltier's tutorial on stacked clustered charts.

 

[phillygirl777]

Yes, thank you very much - greatly appreciated. Very creative and easy on the eye