I'm using a pivot chart in Excel to display data. My problem is: I can not influence the orientation of the text in the "axis" (don't know how to call it correctly, I'm sorry).
As an example: In the following chart I'd like the text marked in yellow also be oriented horizontally:
If I right-click on the chart and select "Format axis..." I can choose the orientation, but that only influences the texts "diff" and "imp", but not the rest.
I've also uploaded the example file: http://www.file-upload.net/download-6764939/SuperuserExcelPivotAxisLabelExample.xlsx.html
Some interesting facts:
- If I right-click on the vertical axis, select "format axis..." and then change the text orientation from "horizontal" to something else, it affects only the values "A" and "B" on the right, but not the P.. and "blonde/brown" (strange!)
- I copied the sheet with the example chart to a new workbook and suddenly all the text orientation in the axis was ok (even more strange!!), apparently as it converts the pivot chart into a normal chart without pivot function, so that does not help me either.
So the problem seems to be related to Pivot Charts...