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.
D'Anna
Hi D'Anna,
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.
Mynda
I was afraid that's what your answer would be.
Thanks for looking, and for offering an alternative.
