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)?

Perhaps post a small sample sheet showing what you have and expected results?

__________________
Using O365 v2503 - Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post