PivotChart resizing problem

[Michael Styles]

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...

 

[Jon Peltier]

Format the chart area so that the chart moves but does not size with cells.
This is on the Properties tab of the Format Chart Area dialog in Excel 2003.
I forget where it is in 2007.

- Jon
-------
Jon Peltier, Peltier Technical Services, Inc.
http://PeltierTech.com/WordPress/
Advanced Excel Conference - June 17-18 2009 - Charting and Programming
http://peltiertech.com/Training/2009-06-ACNJ/AdvExcelConf200906ACNJ.html
_______

 

[Michael Styles]

Thanks. My workaround was doing the job, but its good to know there is an
actual setting controlling that. I was getting frustrated watching my chart
suddenly shoot across to the right of the screen.