Pivot Chart Field Button Not Displaying All Words or Text

Jeannie has an issue with the text in the pivot chart field buttons being truncated.  The full field name does not get displayed.  Instead, just a few characters from the first word are being displayed.

Pivot Chart Field Button Resizes with Sheet Zoom

The pivot chart field buttons cannot be re-sized.  Unfortunately the field buttons cannot be resized with VBA either.

However, the sheet zoom seems to have an effect on the field buttons.  Changing the sheet zoom to 100% should resize the buttons back to normal, to display all the text in the button.

I have not been able to recreate this on my own computer, so please leave a comment with any other suggestions.  Thanks!

  • Search
    Generic filters
    Exact matches only


    Learn 10 great Excel techniques that will wow your boss and make your co-workers say, "how did you do that??"
    Plus weekly updates to help you learn Excel.

    Download the eBook

    Excel Shortcuts List

    keyboard shortcuts list banner

    Learn over 270 Excel keyboard & mouse shortcuts for Windows & Mac.

    Excel Shortcuts List

    Join Our Weekly Newsletter

    The Excel Pro Tips Newsletter is packed with tips & techniques to help you master Excel.

    Join Our Free Newsletter

    About Me

    Jon Acampora Profile

    Hello and welcome! My name is Jon Acampora and I'm here to help you learn Excel.

    This blog is updated frequently with Excel and VBA tutorials & tools to help improve your Excel skills and save time with your everyday tasks. Subscribe above to stay updated. More about me...


    Free Excel Training Webinar Modern Power Tools