Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 01-19-2023, 11:53 AM
rcmv rcmv is offline How to create multiple pivot charts with different metrics from the same pivot chart? Windows 10 How to create multiple pivot charts with different metrics from the same pivot chart? Office 2021
Novice
How to create multiple pivot charts with different metrics from the same pivot chart?
 
Join Date: Jan 2023
Posts: 1
rcmv is on a distinguished road
Default How to create multiple pivot charts with different metrics from the same pivot chart?

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?
Reply With Quote
  #2  
Old 01-23-2023, 02:19 AM
Debaser's Avatar
Debaser Debaser is offline How to create multiple pivot charts with different metrics from the same pivot chart? Windows 10 How to create multiple pivot charts with different metrics from the same pivot chart? Office 2016
Competent Performer
 
Join Date: Oct 2015
Location: UK
Posts: 221
Debaser will become famous soon enough
Default

You have to use separate pivot tables.
Reply With Quote
  #3  
Old 01-23-2023, 03:20 AM
p45cal's Avatar
p45cal p45cal is offline How to create multiple pivot charts with different metrics from the same pivot chart? Windows 10 How to create multiple pivot charts with different metrics from the same pivot chart? Office 2019
Expert
 
Join Date: Apr 2014
Posts: 863
p45cal has a brilliant futurep45cal has a brilliant futurep45cal has a brilliant futurep45cal has a brilliant futurep45cal has a brilliant futurep45cal has a brilliant futurep45cal has a brilliant futurep45cal has a brilliant futurep45cal has a brilliant futurep45cal has a brilliant futurep45cal has a brilliant future
Default

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
Reply With Quote
Reply

Tags
pivot charts

Thread Tools
Display Modes


Similar Threads
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
How to create multiple pivot charts with different metrics from the same pivot chart? multiple charts in pivot tables olybobo Excel 1 05-06-2016 12:26 AM
How to create multiple pivot charts with different metrics from the same pivot chart? Create PIVOT chart using few rows in pivot table Santhosh_84 Excel 1 08-31-2015 06:22 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 12:22 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft