Make SECOND x axis rotate on pivot chart

[bauer24]

Morning all (UK user here),

I've made a pivot chart (simple line chart) in Excel 2007 that has two X axis categories (i.e. two fields in the row labels section). Since the X axis labels are quite cluttered I want them BOTH rotated to read vertically, but it seems I can only rotate the one axis?

Anyone know if there is a hack to fix this?

Many thanks

 

[Jon Peltier]

You can only adjust the orientation of the inner set of labels.