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

**Bernie Deitrick** · 03-31-2014, 10:31 AM

Oops - I replied to myself initially...

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

**behrensf84** · 03-31-2014, 02:11 PM

Oh. Thanks Bernie!

I didnt know it was possible to do that! It's an Awesome trick that's going to eliminate some 50 lines of code for me.

Do you also know if its possible to program a pivot table slicer so that a person cannot select more than 1 item at a time? (ie, they wouldn't be able to use the shift key or the control key and select multiple items). I can do it with an action button, but I would like to be able to do it by clicking on the slicer.

thanks!