Tighten Up Stacked Chart

**erock24** · 05-10-2010, 11:15 AM

I've created a stacked chart clustered by month. Is there a way to tighten up the gaps between each month? I want to keep the month labels centered, but I'd liket the month groups to be closer together. Is this possible??

Thank you.

**Andy Pope** · 05-10-2010, 11:31 AM

In xl2007 you can add another series to the secondary axis.

I have removed 1 of the rows between each month.

**erock24** · 05-10-2010, 11:52 AM

Thanks that works good, as far as 2003 goes is this the best it can do?

**Andy Pope** · 05-10-2010, 12:05 PM

You can use the secondary axis but this time set the Alignment offset to 1000.

Remove the primary x-axis labels and replace those with data labels from another dummy series on the primary axis plotted as line chart type.