Graphs not updating from VBA run code from other sheet

Hello EE!

I have a Sheet1 containing a pivot slicer and a graph
While I in sheet2 have the actual pivot

In Sheet2, under a

Sub Worksheet_PivotTableUpdate(ByVal Target As PivotTable)

Select allOpen in new window

It calculates data for a graph based on the pivot data. This I've checked to work.
What does not seem to work though, is this module:

Sub DoGraph(TheSheet As String, TheChart As String, TheSeries As Integer, XValues As Variant, YValues As Variant)
    With Worksheets(TheSheet).ChartObjects(TheChart).Chart
        With .SeriesCollection(TheSeries)
            .XValues = XValues
            .Values = YValues
        End With
    End With
End Sub

Select allOpen in new window

I'm then using
DoGraph "Sheet1", "name of graph", "1", XValues, YValues

The slicer, the pivot, the module and the call of the module all worked when it was done in one sheet. However after I moved the pivot to sheet 2, it suddenly does not update the graph.

Is this a restriction in Excel or did my DoGraph break when i started adding Worksheet(TheSheet) instead of the previous Me?