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.