Multiple Stacked Columns

Question

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

Answer 1

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é.

Answer 2

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

Answer 3

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

Answer 4

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

Answer 5

Jon Peltier is usually one of the best places to start for chart questions: https://peltiertech.com/clustered-stacked-column-bar-charts/