Pivot Chart with 2 horizontal axis field (categories)

J

Joe

I've created a pivot chart that has two horizontal axis fields. The chart
labels are too long to display properly and overlap each other. When I try
to modify the axis labels, I can only modify one of the categories. How can
I modify the other category labels?
 
A

Andy Pope

Hi,

When using multi-level category labels only the inner most level can be
formatted. True of Pivot chart and normal charts.

Cheers
Andy
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Bar Chart in Excel 2010 does not display neither Horizontal axis labels, nor legend 0
change chart primary horizontal axis label or name 1
Doughnut Chart linked with the slicer in the pivot table 0
Scatter chart with categories on x-Axis 2
Axis labels wrap until print/print preview 3
Pivot Chart - X-axis labels when adding data 0
Adding a line to a population bar chart 0
Text-wrapping horizontal axis labels 4

Top