Hi:

I currently have a pivot table with several field lists. The data is linked to a chart. I inserted active control checkboxes on the chart so that different pivot items can be selected and deselected from the field list based on if the check box is checked or not (recorded a macro that go's into the field list and simply checks the boxes I want or un-checks them in the field list.

What I'd like to do is have a dynamic macro that looks for the pivot item in the field list matching a specific cell on this worksheet or another worksheet. This cell changes from month to month so I'd like it to be dynamic rather then one I recorded based on the current month's value. I have yet to find a way to have the pivot item linked to a cell in the worksheet.

Thanks,