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!

1 comment

Your email address will not be published. Required fields are marked *

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