| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Refresh pivot chart when info in a cell changes
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. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Refresh pivot chart when info in a cell changes
Excel 2007, PivotTable
With Table dependent drop-downs instead of data validation drop-downs. With non-event-driven macros. http://www.mediafire.com/file/ygzjqyi2j1x/03_09_10.xlsm |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Pivot Chart won't refresh! | Charts and Charting in Excel | |||
| Pivot table and chart refresh not an option | Excel Discussion (Misc queries) | |||
| Pivot Chart won't refresh in Excel 2007 | Charts and Charting in Excel | |||
| refresh pivot chart | Charts and Charting in Excel | |||
| Pivot Chart Refresh cancels all chart formatting | Charts and Charting in Excel | |||
Linear Mode
