Adjusting scale on Slicer

I have created my pivot table and pivot chart. I have added the following code to have the scale on the secondary axis match the primary axis:

Please Login or Register  to view this content.

The problem is that now when I use my slicer the secondary axis scale remains the same as the summary and does not adjust to match the individual selections.

Summary.png

Work Center Selected.png

How can I code it so that the secondary scale always matches the primary scale no matter the data set?

I have posted this on MrExcel on Wednesday with no response yet, I am a bit anxious as I need to have this complete for presentation to Ownership on Monday morning. Any help is greatly appreciated. I tried posting a link to original posting but I have too few posts.

You need to rerun the code each time the pivot table changes.

You can do this by placing the code in the PivotTableUpdate event

[code]
Private Sub Worksheet_PivotTableUpdate(ByVal Target As PivotTable)

End Sub
[code]