Make the scale of one chart dependent on the scale of another chart

Sure - just use the PivotTableUpdate event to call the macro: in the codemodule of the sheet with the pivot table

Private Sub Worksheet_PivotTableUpdate(ByVal Target As PivotTable)
 Macro2  'Use whatever you named the macro based on my code
End Sub