Pivot Chart update



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?????




Hi Sharon I have a Pivot Chart in EXCEL 2007 on the screen in front of me.

There isn’t a setting that needs to be turned on.

In my PivotTable Field List I have two items selected:-


Revenue Last Year

I have another field:-


- 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.


Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question