1. The defined range changes depending on how many rows are merged within each individual workbook. How do I get the PivotTable (and subsequently PivotChart) to be auto-updated when the number of rows increase?
2. The Pivotchart only has options for “Quarter” or “Year”. How do I enable it to segment by months?
3. How do I show a cumulative Pivotchart by months (instead of total by month)?