![]() |
|
![]() |
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
![]() I have a pivot table from which I would like to create several pivot charts of the same type (lines) but with different metrics of the pivot table. What happens is that whenever I create a new chart and select a new metric, the previous chart also change to current metric. How can I avoid this? |
#2
|
||||
|
||||
![]()
You have to use separate pivot tables.
|
#3
|
||||
|
||||
![]()
The pivot tables/charts need to have their own pivotcaches. See https://www.contextures.com/xlpivot11.html#newcache
Also: Stop all the pivot tables applying the same grouping method • You could try Ashish Mathur's suggestion here: Redirecting also: Unshare a data cache between PivotTable reports - Microsoft Support |
![]() |
Tags |
pivot charts |
Thread Tools | |
Display Modes | |
|
![]() |
||||
Thread | Thread Starter | Forum | Replies | Last Post |
pivot chart for multiple data sets | md0627 | Excel | 1 | 01-08-2023 05:17 PM |
pivot chart equivalent | dt2810 | Word VBA | 1 | 04-16-2019 05:21 PM |
Help creating a chart and/or a pivot | jerrysmith | Excel | 1 | 01-17-2017 04:38 PM |
![]() |
olybobo | Excel | 1 | 05-06-2016 12:26 AM |
![]() |
Santhosh_84 | Excel | 1 | 08-31-2015 06:22 AM |