Excel Summary Report AutoFilter Options for Pivot Tables and Pie Charts

[Lavenderchan]

Hello,

I need some imput on how to autofilter pie charts with pivot tables. I have a workbook that I am setting up to filter records. . I have one worksheet that contains all of the data. One summary work sheet. I have a combox in therory once a name is selected then all records assoicated to it show filter down. I have three levels the director, teams and the to individual team members. I have used the subtotal function to filter the numerical totals. However I have six pie charts that need to sort that isn't and I am not sure what the best way is to do that.

Thanks,
Keri

 

[SkipVought]

Hi,

Is there a problem? If so then please describe the problem clearly, concisely and completely.

For instance, you state that you have 6 pie charts that need to sort. What does that mean? I have NEVER sorted a chart!

Skip,
[sub]
Just traded in my OLD subtlety...
for a NUance![/sub]