Dynamic Pivot Table and Chart Cell References with slicers - HELP

It would be better if we had an actual workbook to work with.

Your problem sounds very much like one I face where I want to plot something that is calculated as percent of column. I solved it using dynamic ranges. Instead of a slicer, I have a simple dropdown list that is also dynamically generated.

Attach a sample workbook. Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

Remember to desensitize the data.

Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.

No attachment - it's easy to miss a step uploading.

The paper clip icon doesn't work. You have to go through the steps to Go Advance, Manage Attachments, find the file, upload the file then close the upload tab.

I can't read the link you posted.

One of the reasons you might not be able to upload the file is if the file is too big. Cut back on the data (we only need enough to get the idea). You can also save it as a binary (*.xlsb) and if none of that works, compress it and attach the zip file.

I did a couple of things.

There was something wrong with the your source data table. it wasonly "showing" two months. I rebuilt it. I attached the pivot table to the excel data table instead of the range. Now the pivot table will reference the correct data regardless of how many rows there are in the table.

I also added a helper column that concatenates life cycle stage and channel.

Then I added in a whole new helper sheet with a pivot table similar to the one you have displayed. This pivot table is linked to the same set of slicers that control the main table.

Rows 1 and 2 find the column in which an item to plot is found. If, as a result of filtering, an item disappears, it points to column 13 which is blank.

I use the column numbers to define a number of named dynamic ranges such as Plot_Active_BVM. I substituted the named ranges for your fixed ranges.

These two wikis explain the concept behind the dynamic charting.

http://www.utteraccess.com/wiki/Offs...Dynamic_Ranges
http://www.utteraccess.com/wiki/Dynamic_Charting