Adjust Page Breaks Automatically With a Pivot Refresh
Posted on 2011-03-15
In Excel 2007, I have a pivot and a chart a few rows underneath it. Whenever the pivot refreshes, and new rows are added, the pivot overlaps the chart. How do I get it to just insert rows and move the chart down when the pivot adds new rows? I don't want to keep having to update the page breaks. I'm having the same problem when a new column is added to the pivot. In the file, the cell A1 is merged across to the end of the pivot going across. When a new column is added to the pivot, the merged cells do not extend all the way to the new column. Can this be done automatically?