Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Help with listbox from pivot table with dynamic data
Hello,
I have a chart with sources coming from a pivot table. The filter fields are workcenter and machine. There can be multiple machines in a workcenter. On the chart sheet, I have two control listboxes, one for workcenter and one for machine selection. Once the workcenter listbox is selected it will filter in the pivot table, then in turn update the graph based on the pivot table data. The problem I dont know how to resolve is how the machine listbox is depending on the workcenter selection. When user selects a workcenter from the listbox, it will update the chart based on workcenter filter in the pivot table, but then I need the machine listbox to list only the machines that are in the selected workcenter. Finally, if the user selects a machine from the machine listbox, it will filter the machine also in addition to the workcenter. Thanks for any help. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
use dynamic data source to make pivot table | Excel Discussion (Misc queries) | |||
vlookup data in a dynamic pivot table? | Excel Worksheet Functions | |||
pivot table with dynamic base data | Charts and Charting in Excel | |||
Pivot table, dynamic data formula | Excel Discussion (Misc queries) | |||
Pivot Table & Dynamic data | Excel Programming |