I'm using Excel 2007. I created a simple 2 column pivot table and a pivot
chart based on the table. When I change the filtering on the table the chart
doesn't update to the new values like it is supposed to. Is there a setting
somewhere that needs to be turned on or what?????