Forum Discussion
Pivot Table column label from horizontal to vertical
After pivot table and with grouping, some column labels have been showed but the caption is on the top. What i want is put the column header at the left of the row as vertical red text show as below. However, i cannot do this, it said "We cant change this part of pivot table".
What can i do for this case if necessary? I have attached the file FYR.
6 Replies
- Did you find a solution? Your wanted setup is visually more pleasing to me as well.
Thanks for your reply. Not really like that, User requested to show the grouping by vertical, if in row then not meet their requirement.
george2175 Sorry, not sure I follow you here. Perhaps like this then? (see attached).
If not, perhaps you can mock-up a table and demonstrate how it should look like (what should be on the row headers and in what order, and what on the column headers.
