Rotate x category labels in a pivot chart.

**guntherda** · 05-30-2013, 05:33 PM

OK so I figured out how to rotate the primary x axis to a -90 degree orientation. Does anyone know how to rotate the second category of the horizontal axis? that labels run together making them illegible

**scott.s.fower** · 05-30-2013, 06:12 PM

can you upload the actual chart and not a just a picture

**guntherda** · 05-31-2013, 11:31 AM

Here is the spreadsheet. Thanks for taking a look.HI_CR_SM_2.xlsx

**Andy Pope** · 05-31-2013, 11:47 AM

for charts with multi level axis labels only the inner level reacts to alignment setting.

**guntherda** · 05-31-2013, 12:37 PM

Thanks Andy,
I was hoping that would NOT be the answer and someone had a method to align the outer axis. Seems Like that ought to be fixed. Does anyone know if Excel 2010 added this feature.