|
|
#1
02-13-2017, 03:24 AM
|
|||
|
|||
Pivot
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)? 
|
|
#2
02-13-2017, 04:34 AM
|
||||
|
||||
|
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
|
|
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
 Create PIVOT chart using few rows in pivot table
|
Santhosh_84 | Excel | 1 | 08-31-2015 06:22 AM |
| Pivot Tables | MSA5455 | Excel | 2 | 02-03-2015 06:02 AM |
|
pivot table
|
aliasadi_07 | Excel | 1 | 03-11-2012 12:49 AM |
|
Pivot Table
|
Karen615 | Excel | 5 | 08-03-2011 10:46 AM |
| Pivot Question | rejubinu@gmail.com | Excel | 1 | 01-21-2011 02:25 PM |
Windows 8 
Office 2013
Linear Mode
