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. Anonymous
    2022-04-29T00:40:05+00:00

    Hi. If you don't get a better solution, perhaps:

    10 people found this answer helpful.
    0 comments
  2. Andreas Killer 144.1K 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
  3. Anonymous
    2022-04-28T23:25:38+00:00

    Hi

    My name is André. I am an independent consultant.

    >Basically you need the data, and insert a Chart of columns, according to the print. And then you can adjust the layout options according to your needs, using the color and formatting options.

    Answer here so I can continue helping you.

    André.

    3 people found this answer helpful.
    0 comments
  4. Anonymous
    2022-04-29T01:00:29+00:00

    Getting closer to what I need. How to push the month columns closer together (I tried adjusting the gap width, but that seems to adjust all of the columns. Also, how to center the Month below the 2 columns? Can't find helpful hints in Excel.

    Much appreciated.

    I'll keep trying too

    0 comments
  5. Anonymous
    2022-04-29T00:00:28+00:00

    Thank you Andre

    I need to show each month results in 2 columns, not 1.

    When I use column chart with this data, I can't figure out how to make each month 2 columns.

    Thank you
    Jerseys Uniforms Footballs Baseballs
    Jan 750 200 800 550
    Feb 600 450 375 600
    Mar 780 630 700 500
    0 comments