Extract text of a filter parameter into a cell

[curtishavak]

Does anyone know of a way to have the text of the filter parameter that has been applied to a chart to be displayed in a cell?

I have my Pivot Chart title linked to a cell within the spreadsheet to allow for a dynamic title. I'd like for the title to also change as I select a new filter value.

For example, I have a chart that displays revenue within a given time period. Anytime that I select a specific market segment in the slicer or by filter, I'd like for the name of that market to populate a cell that can be referenced as part of the dynamic title name.

Chart Title (No Filter): Order Report
Chart Title (Filter Market Segment Cardio): Cardio Order Report

Any ideas? Thanks Interwebs!