Pivot chart won't change when I add months using the slicer

[Mrs.H]

Hi, this is my first post ever on a forum such as this, so bear with me while I learn the protocols I have made a pivot chart (pie) to show some department metrics. I have 2 slicers, one for crew and one for month and year. When I choose one month I am able to pick just one crew or multiple crews and show an accurate graph. However, if I choose just one crew, but try to choose multiple months the graph will stay at whatever the first month I picked was, and will not update to include the additional month(s). Does anybody know why this could be? Am I able to attach screen shots, etc. to illustrate my problem? Any advice to possibly shed some light on this would be greatly appreciated!

Thanks in advance!

[Mrs.H]

Hope I did this right

[FDibbins]

Apart from Jan-15, I can get all months to show in the chart

[Mrs.H]

Thanks for trying! What I'm trying to get it to do is show a couple months at a time. For example, if I pick Grounds as the crew and pick July, but then add August, the chart doesn't change. The pivot table changes, but the pie chart does not update to match it. Any ideas why this might be?

[stasinek]

try it now, according to me it is ok

[Mrs.H]

stasinek, you're my hero! how did you get it to do that?

[Mrs.H]

Actually I just figured it out, THANK YOU SO MUCH, it was driving me crazy! I knew it was going to be something simple like that