Hide and show pivotfields with vba

Can you provide a sample workbook?

Example Spreadsheet.xlsmI hope this attachment works. I just made a quick example of basically what I am trying to do. This is my first time using the forum. Thanks for any help you can give.

Took me a while of messing around with it, but this should work:

Please Login or Register  to view this content.

Thank you so much. I had looked for hours trying to figure this out. I modified the code to work with a check box. It worked like a charm

Please Login or Register  to view this content.

Awesome! Glad I could help.

So now I am trying to apply this to my chart at work and I am having trouble with the

Please Login or Register  to view this content.

part of the formula. When setting it on another chart what property should I change and how would I find it?

That code selects the 1st pivot table on the sheet "Pivot Table". Make sure the sheet name is right. Is your chart using a pivot table as a data source? If so, you can just change the pivot table and the chart will change. Otherwise you can do something like Sheets("Sheet Name").Charts(1) or Sheets("Sheet Name").Charts("Chart Name")

You are a genius. Thank you again.

You're more than welcome.