![]() |
#1
|
|||
|
|||
![]()
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)? |
Thread Tools | |
Display Modes | |
|
![]() |
||||
Thread | Thread Starter | Forum | Replies | Last Post |
![]() |
Santhosh_84 | Excel | 1 | 08-31-2015 06:22 AM |
Pivot Tables | MSA5455 | Excel | 2 | 02-03-2015 06:02 AM |
![]() |
aliasadi_07 | Excel | 1 | 03-11-2012 12:49 AM |
![]() |
Karen615 | Excel | 5 | 08-03-2011 10:46 AM |
Pivot Question | rejubinu@gmail.com | Excel | 1 | 01-21-2011 02:25 PM |