Refresh pivot chart when info in a cell changes

J

Joel

To all,

I am looking for help with a Macro. What I ultimately want to do is refresh
a pivot chart when the user makes a selection from a list (in a data
validation cell). For example, I am an end user that selects my territory
from a "drop down". The pivot chart will update to the information that is
directly related to my territory. Thanks in advance for your help.
 

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

Similar Threads

When refreshing pivot tables my pivot table chart type changes 1
Pivot Table Chart? 4
Duplicating Pivot Chart / Changing Pivot Chart data range 4
Excel 2k Pivot Table refresh scenario 1
Maintaining colours in a pivot chart 1
Pivot Table Refresh? 1
chart formating disappears when i refresh pivot table data 3
Pivot Table - Changes 5

Top