Help with listbox from pivot table with dynamic data

C

Cam

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 don’t 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.
 

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

Help list box to update pivot table 1
Dynamic link with 2 dependent listbox? 0
Multiple listboxes to update pivot table? 1
Doughnut Chart linked with the slicer in the pivot table 0
Create a chart from a table in word thats dynamic 0
Dealing with a Pivot Table (when I don't want to) 0
How I can set dynamic pivot table ONLY when I have enough data point 1
Unable to get the Values property of the Series Class 1

Top