Pivot Chart update
Hi Sharon I have a Pivot Chart in EXCEL 2007 on the screen in front of me.
There isnt a setting that needs to be turned on.
In my PivotTable Field List I have two items selected:-
MARKET
Revenue Last Year
I have another field:-
REGION
- turned off at the moment.
I drag REGION to Report Filter.
If I now select a REGION in the Pivot Table (a REGION called MIDWEST) and
hit OK the chart updates to reflect that change immediately so I do not seem
to be able to re-produce the behaviour that you are seeing.
If my comments have helped please hit Yes.
Thanks.
"Sharon" wrote:
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?????
|