Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello-
I would like to change the cell alignment of one of the columns in my pivot table. I would like the text to be at the top of the cell, readily visible to users, rather than at the bottom of the cell. Currently users would have to scroll a ways down to see the text. I've tried Custom Format Cell, but that feature does not allow me to change the alignment of the cell.
Thank you in advance!
-Tina
Hi Tina.
If you go into the chart properties presentation tab you can set the Alignment. Change the Data(Vertical) alignment to Top.
John.
Hi John-
I tried that too and it didn't work. Maybe there is some other setting I need to change?
Thank you!
-Tina
Hello-
I figured out why that didn't work. In the Properties, Style Tab, I had Indent Mode checked. Once I unchecked that the alignment settng worked correctly.
Thanks!
Hi Tina.
Could you attach a sample application with the alignment issue?
John.