Help needed for Dynamic Chart Title

%3CLINGO-SUB%20id%3D%22lingo-sub-2061169%22%20slang%3D%22en-US%22%3EHelp%20needed%20for%20Dynamic%20Chart%20Title%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2061169%22%20slang%3D%22en-US%22%3E%3CP%3E%3CSPAN%3EI%20have%20a%20pivot%20table%2Fchart%20created%20for%20donors%20to%20our%20organization.%20I%20want%20a%20dynamic%20chart%20title%20to%20display%20the%20individual%20donor%20name%20when%20filtered%20through%20a%20slicer%20but%20if%20all%20are%20selected%20I%20want%20the%20chart%20title%20to%20say%20%22All%22%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2061169%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2062746%22%20slang%3D%22en-US%22%3ERe%3A%20Help%20needed%20for%20Dynamic%20Chart%20Title%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2062746%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F929215%22%20target%3D%22_blank%22%3E%40jimcramer%3C%2FA%3E%26nbsp%3BBy%20best%20guess%20is%20to%20create%20a%20unique%20id%20reference%20that%20can%20use%20the%20INDEX%2FMATCH%20function%20to%20link%20back%20to%20your%20title%20-%20here's%20an%20%3CA%20href%3D%22https%3A%2F%2Ftrumpexcel.com%2Fdynamic-chart-titles-in-excel%2F%22%20target%3D%22_self%22%20rel%3D%22nofollow%20noopener%20noreferrer%22%3Eexample%20of%20that%3C%2FA%3E.%20If%20would%20be%20better%20if%20you%20can%20share%20a%20sample%20file%20of%20the%20slicer%20you're%20using%2C%20without%20sensitive%20data.%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Visitor

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"

1 Reply

@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 example of that. If would be better if you can share a sample file of the slicer you're using, without sensitive data.