PivotTable slicers and filtering removes secondary axis for chart

Hello,

I have a large worksheet that I am working on, but everytime I filter and or use the slicers the secondary axis I setup goes away.
Is there a way to circumvent this? Attached is a sample workbook with the correctly formatted chart.

I found the following forum post from 2013. Where is the pivotchange event, and how do I add code to the pivotchange event to reset the chart formatting as stated in the post below?

https://www.excelforum.com/excel-cha...-my-graph.html

char2ndtAxis.png

Originally Posted by Andy Pope

The pivotchange event would be in the sheet object that the pivot table is on.

As you have your pivotchart on a chart sheet you can use the change event of the chart.
Right click chart tab and pick View Code. Paste the following

Please Login or Register  to view this content.

Wow thank you so much for this! I understand what's the code is doing based on my research on the InStr function. I also want to add a primary and secondary label to the vertical access, but I am getting a runtime error 424, object required (red line). Building on your code I've added the following:
It's my understanding that the code within the With Loop all belong to the same object, ActiveChart, so I don't know why I get the error.

Please Login or Register  to view this content.

Originally Posted by Andy Pope

Please don't quote whole posts -- it's just clutter.*If you are responding to a post out of sequence, limit quoted content to a few relevant lines that makes clear to whom and what you are responding

Will do. Thank you for the revision. It works perfectly.

I am trying to use the above example to solve this issue, however I am finding if my slicer choice does not have any data for the secondary axis, then I remove the filter - the secondary axis disappears. The above code did not resolve this issue. I am using Power Query to link to over 600,000 lines of data. I am a self taught novice - so please if you are so kind to respond I may not fully understand acronyms or "excel speak"