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

    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

    Free Excel Training Webinar Modern Power Tools