Pivot Chart update


S

Sharon

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

Advertisements

T

trip_to_tokyo

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

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.
 

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

Top