In a pivot chart, I am using two values on the horizontal axis (axis categories). The Month/Year is sorted by Class Count (ascending), but when I expand both axis categories (to show both the Class Session and Month/Year) then the formatting of the Month/Year changes to horizontal and will not fit in the space allotted. I have not been able to figure out how to have both the Class Session and Month/Year to rotate 270 degrees. Only the first of the two values will rotate. The other will be horizontal.

How do I show both values on the horizontal axis and get both to format rotated 270 degrees?

Thanks in advance,
Andrew

Attached Images

horizontal axis.jpg (135.7 KB, 11 views)