Why are separate pivot charts being filtered simultaneously?

[BSWJON]

I would appreciate your help with this conundrum.

I have a table, feeding 3 separate pivot tables. These in turn are summarised with separate pivot charts.

When I filter the axis categories using the button on graph 1, it filters graphs 2 and 3 also- even though they come from different pivot tables.

I'm not using connected slicers to filter the graphs (I've deleted them in an attempt to solve this issue).

How can I stop this from happening?

 

[awoohaw]

Pivot tables usually use the same cache so when you use the same cache it filter all pivots.
You can fix that easily. Take a look at this video:

 

[Alex Blakenburg]

The only way that I could replicate that behaviour was for the chart to be using the same Pivot Table.
Unfortunately the Pivot Chart only show the underlying data source and not the table it is based on.
Try runnning the slightly modified code below
sourced from:

https://yoursumbuddy.com/finding-a-pivotcharts-pivot-table/

If your charts are on multiple sheets uncomment my "set ws" line and reinstate the "For Each ws" & "Next ws" lines.

What you are looking to see is if the charts are using the same Pivot Table name which will be the first item in the message box.

Sub GetPivotChartSources()
Dim ws As Excel.Worksheet
Dim chtObject As Excel.ChartObject
Dim cht As Excel.Chart
Dim pvt As Excel.PivotTable

Set ws = ActiveSheet
'For Each ws In ActiveWorkbook.Worksheets
    For Each chtObject In ws.ChartObjects
        Set cht = chtObject.Chart
        If Not cht.PivotLayout Is Nothing Then
            Set pvt = cht.PivotLayout.PivotTable
            'activate the sheet the pivot is on
            pvt.Parent.Activate
            pvt.TableRange2.Cells(1).Select
            MsgBox pvt.Name & vbCrLf & " is on " & pvt.Parent.Name & " using data from " & pvt.SourceData
        End If
    Next chtObject
'Next ws
End Sub

 

[BSWJON]

Hi both,

Thanks for your responses.

Unfortunately neither solution worked- so I ended up deleting the pivot tables and starting again. No issues the second time around.

An annoying problem and it would have been nice to have found a more elegant fix than deleting everything but hey ho.

 

[Alex Blakenburg]

Thanks for letting us know. Sorry we couldn't save from having to recreate the pivot tables.