Overlapping Primary and Secondary Axis in Charts

Hi,

I am trying to create a bar chart such that a few series is represented on the left side of the chart and few on the right side. I am looking for something as shown in the attached image.

I am using Excel 2010. Tried everything but could not get through.

Can someone please help me out here.

Thanks Andy for your response.

Yes I did that and created the chart once but going forward it will be no good as the values in the Band A, B C and D are counts. And I may have to do every time I create the chart.

Was just thinking of some other way to do it.

Actually Let me explain my requirement. I am trying to plot the aging of tickets for different teams. It has got 4 different buckets. Any ticket which has the aging greater than 5 days is highlighted (shown in light red and dark red colors).

The problem here is, I do not want to make the count of tickets negative for plotting the chart. I am looking out for some way so that we can directly plot the chart without altering the data.

Attaching a sample workbook for your reference.
Sample data.xlsx

Thanks Andy. This is what I wanted in chart.

Sorry for being lame.... Can you please tell how you plotted the chart. Because when I plotted it was looking something like in the picture attached.
Chart-1.jpg