Dual Axis - Different Dimensionality?

Please see attached.

I'm creating a Dual Axis chart, combination of Bar and Line. As per the attached workbook, I basically need it to look like Sheet 1 except that I need the bars side by side.

I believe the only way to do this is to pull 'Store_Brand' out onto the columns shelf, but this will screw up the line series, as per Sheet 2.

Is there anyway I can achieve this?

Thanks!