May 15, 2019
Hi, Attached is a picture of the multi-category chart I'm trying to format the label on. I am hoping you have a solution for how to format them so they're easier to read when we're presenting them to corporate. We want the unit name and its number on each line (the screenshot with the circle is what we really want). Not just the unit number (screenshot with no circle).
I've also attached the handwritten drawing that I attempted to create in a pivot chart using a query I've made.
Thank you for your help.
Btw, I have really learned so much from the tutorials and help topics on your website. Y'all have taken my Excel game to a whole other level. I sincerely appreciate all your newsletters, this forum, etc.
July 16, 2010
Welcome to our forum.
Unfortunately, you can't change the orientation of the vertical axis text. The labels closest to the bars will always be horizontal and all other labels will be vertical.
Perhaps in-cell charts will suit you better. This way you can place your labels in cells and control the text orientation.