Evenly space bars within hierarchical bar chart

I'm having a problem trying to improve the formatting of a chart. I may actually be going about this all wrong. Below is a screenshot for illustrative purposes...

Screen Shot 2015-01-23 at 7.59.40 PM.png

The chart has 7 series. The high-level category has two levels: intervention and comparison. The lower-level category also has two levels: target and non-target. The pharmacy, general retailer, itinerant drug vendor and ALL target series only have values within the target category. The private facility, health worker and ALL non-target series will only have values within the non-target category.

Currently, the series are not centered within their respective categories because the series that don't belong in the category have zero values so they are taking up real estate on the x-axis.

Is there a way to center the series within their respective categories? Any help would be greatly appreciated.

Hi Brendan, thanks for your reply. I'm not quite sure how I can resolve this problem by hiding rows with zero values. I think the issue is that there are no rows with only zero values. Each series/row has 2 non-zero values (for the categories they fall within). Perhaps, I'm not understanding the solution? Attached is a workbook.

Hi Brendan, this worked perfectly! I've got a lot to learn about formatting Excel charts. Thanks!

Kevin