Pivot Chart with 2 horizontal axis field (categories)
 

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?

Pivot Chart with 2 horizontal axis field (categories)
 

Hi,

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

Cheers
Andy

Joe wrote:
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?

--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info