Forum Discussion

Copper Contributor

Jan 14, 2021

Help needed for Dynamic Chart Title

I have a pivot table/chart created for donors to our organization. I want a dynamic chart title to display the individual donor name when filtered through a slicer but if all are selected I want the ...

excel

Formulas and Functions

adversi

Iron Contributor

Jan 14, 2021

jimcramer My best guess is to create a unique id reference that can use the INDEX/MATCH function to link back to your title - here's an https://trumpexcel.com/dynamic-chart-titles-in-excel/. If would be better if you can share a sample file of the slicer you're using, without sensitive data.