moving 2 columns so they are right next to each other

[greense1]

I am trying to graph a comparison chart from a previous month. I can't figure out how to get the bars so they are right next to each other for the given category. For instance I want the Sept and Jan bars centered and touching each other for the "Are there approx 4-7 KPI's documented?" series etc. Anyone have any tricks or ways to make this happen? It would be much appreciated.
GJHG.png

[thisoldman]

I rearranged your data. There sre dummy series with no values between each pair of columns in the 100% stacked column chart. Gap width was set to 8%.

clustered_and_stacked_reduced.png

[protonLeah]

It does not help this forum for the OP and responders to post only pictures of worksheet.

[thisoldman]

Oops! Did it again. Burned twice, so now I'll remember.

File: clustered_and_stacked.xlsx

I prefer charts of this size as bar charts. For me, they are easier to format.
File: bar_chart_clustered_and_stacked.xlsx

[greense1]

It does not help this forum for the OP and responders to post only pictures of worksheet.

It was my first time posting. I'll know better next time. I found it very helpful though. Thanks thisoldman!