4
0
As part of a dashboard, I've created a PivotChart from a PivotTable in Excel 2010, but the PivotTable includes extra columns that are cluttering up the chart. But when I adjust the values list on the PivotChart, those values are also removed from the PivotTable. Unfortunately, my end users need to see all those columns in the PivotTable, but with a cleaner PivotChart. Is it possible for me to:
Create a PivotChart from a subset of the PivotTable data
orCreate a separate PivotChart, then link the common values so that they update together?
I'd like to avoid separating the two, because I do want their common filters to apply to both.
I'd simply set up my pivot chart as I want it, then copy the associated pivot table elsewhere, remove any filters that are applied, then hide the original pivot table. – Andi Mohr – 2014-01-02T16:05:15.850
Andi, I'm not understanding all of that. – Frameworker247 – 2014-01-02T17:54:44.887
Ah ok no problem - I'll post a more complete answer. – Andi Mohr – 2014-01-02T18:03:22.357