Clustered Column Chart - Removing Gaps for Zero Value Series

So this question has been asked many different ways, but I can't find a workable solution. I have a clustered column chart that has, for example, 3 categories and 10 series. The third category has a value for each series, while the other two only have values in some of the series. The resulting graph leaves gaps/spaces for those series that don't have values. Is there a way to resolve this to where those gaps/spaces are not there? I've tried populating the 0 value cells with =NA(), but that just removes the data labels.

I've attached a generic idea of what I'm working with. I'm open to suggestions for organizing my data as well. Thanks for any help that can be provided.

Thank you Mr. Pope. Very clever! This is what I was looking for, you were able to keep the series labels static and adjust the values. It may be a challenge to dynamically change the data for each subject category, but nothing a little VBA magic can't handle I wasn't sure what you meant by the axis labeling. Also, is the "pad" series in place because the tick marks can't be used with this format? For some reason, I can't get the tick marks to show up.

That makes sense. I think the PAD is sufficient in providing separation. Thanks again.

I've been playing with this chart idea and I keep running into the same issue. The first multi-level category level is not included because the blank line under the value labels which offsets everything. I tried using your dataset/worksheet and couldn't recreate your graph unless I individually adjusted each series and the category labels. I've attached the workbook with my attempt to create the graph by just selecting the data range. Is there a better way to create this graph?

Book1.xlsx

Wow That works. Most of the time I love that Excel is intuitive, this is not one of those times. Thanks again.