• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

2 Sets of Data - Stacked Chart in 365

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!
 

Attachments

  • Example 01.10.20.xlsx
    15 KB · Views: 5
Looking for something like this?
64895
It requires your data to be organized a bit differently. Have a look at Peltier's tutorial on stacked clustered charts.
 

Attachments

  • Copy of Example 01.10.20.xlsx
    15 KB · Views: 7
Back
Top