Share via

Multiple Stacked Columns

Anonymous
2022-04-28T22:13:06+00:00

I cannot figure out how to build a chart like this in MS Excel 2016. Two types of soft goods, and two types of equipment for each month. Any really clever people with suggestions? Thank you

Microsoft 365 and Office | Excel | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

8 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Andreas Killer 144K Reputation points Volunteer Moderator
    2022-04-29T10:02:44+00:00

    Add a group column to your sales data, create a Pivot table / chart, done.
    That is IMHO the closest possible output to your requirement.

    Sample file:
    https://www.dropbox.com/s/f1c87t0v6v2do1p/487dcf81-130f-44c5-9da3-fa357ab52210.xlsx?dl=1

    Andreas.

    4 people found this answer helpful.
    0 comments
  2. Anonymous
    2022-04-29T21:09:37+00:00

    Thanks Rory

    0 comments
  3. Anonymous
    2022-04-29T21:10:14+00:00

    Trying out your recommendation -- sure wish I was better at pivot tables.

    0 comments