I created a PivotChart that will be used for printing. Whenever I select a
different item in the Report Filter, the spreadsheet column holding the Row
Labels (in this case, rather lengthy questions) resizes itself, up to a
maximum of 255 characters. This also resizes my chart, causing it to
stretch well across several printed pages. The chart is positioned over the
rows holding the Row Labels and those rows are hidden in the worksheet.
After about an hour, I finally discovered I had to set all the cells holding
the underlying data to Text Wrap, then hide them. That then prevents the
columns from resizing.
Is this normal behavior or some quirk in Excel? I doubt a lot of people
will figure out the text wrapping trick on their own.

Michael Styles, MCT, MCP, MCAS, etc...