Forum Discussion

jimcramer's avatar
jimcramer
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 chart title to say "All"

excel
Formulas and Functions

1 Reply

  • adversi's avatar
    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.

Resources