Hiding Pivot Chart Filters in Excel

Asked Aug 02 '16 at 20:59

Active Aug 02 '16 at 21:10

Viewed 187 times

I have a data table that will split into 20 types of Pivot charts. I was hoping to use a filter, so that I could just use the same set of data. I've done it, but each pivot chart has the same repeated filter items on the top.

Is it possible to hide the filters in a Pivot Chart either by VBA or using options that I'm not finding?

edited Jul 09 '18 at 19:34

Community

asked Aug 02 '16 at 20:59

plateriot

tell you a cool trick... try recording a macro. :) – cyboashu Aug 02 '16 at 21:04
Yes, it's my favorite trick. :) I would if I knew how to hide them in the first place. – plateriot Aug 02 '16 at 21:07
in that case always try clicking and right clicking . Check for the new options that excel presents :) By the way see the answer. – cyboashu Aug 02 '16 at 21:11

Hiding Pivot Chart Filters in Excel

0 Answers0