Aligning category Axis in a stacked column chart

**phedax** · 06-01-2013, 07:59 AM

HI,
I created a stacked column chart with more than one bar per category, I now want to move the category labels to the middle of the relevant bars (in the attached file: the 1% should be between the two bottom bars). Seems like an easy thing to do, but cant find out how.

Thanks for your help!!

**Andy Pope** · 06-01-2013, 11:46 AM

You could use multi level labels, as per first chart. You need to put a space in the inner label cells. Problem is the outer labels are vertically displayed.

The second chart uses a dummy series on the secondary axis to display only 4 category labels, correctly aligned and positioned.