SOLVED

Pivot Table Charts - How to make a chart title dynamic based on filter?

%3CLINGO-SUB%20id%3D%22lingo-sub-1730144%22%20slang%3D%22en-US%22%3EPivot%20Table%20Charts%20-%20How%20to%20make%20a%20chart%20title%20dynamic%20based%20on%20filter%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1730144%22%20slang%3D%22en-US%22%3E%3CP%3EI'd%20like%20to%20make%20a%20filter%20selection%20and%20have%20the%20title%20update%20automatically%20on%20my%20pivot%20chart.%20How%20do%20I%20do%20this%3F%20Thanks%20for%20any%20help%20in%20advance.%20So%20-%20In%20the%20pic%20below%2C%20I'd%20like%20to%20change%20the%20filter%20from%20%22Broccoli%22%20to%20%22Cauliflower%22%20and%20have%20the%20chart%20title%20update%20automatically.%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Screenshot%20(56).png%22%20style%3D%22width%3A%20999px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F223088iC5F9DC5AAAFDA6BA%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20title%3D%22Screenshot%20(56).png%22%20alt%3D%22Screenshot%20(56).png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1730144%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1731165%22%20slang%3D%22de-DE%22%3ESubject%3A%20Pivot%20Table%20Charts%20-%20How%20to%20make%20a%20chart%20title%20dynamic%20based%20on%20filter%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1731165%22%20slang%3D%22de-DE%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F676026%22%20target%3D%22_blank%22%3E%40slohombre%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22tlid-translation%20translation%22%3E%3CSPAN%20class%3D%22%22%3EMaybe%20I%20can%20help%20you%20with%20this%20food%20for%20thought.%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FP%3E%3CH1%20id%3D%22toc-hId-555031566%22%20id%3D%22toc-hId-555031566%22%3ERefresh%20PivotTable%20data%3C%2FH1%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Fsupport.microsoft.com%2Fen-gb%2Foffice%2Frefresh-pivottable-data-6d24cece-a038-468a-8176-8b6568ca9be2%3Fui%3Den-us%26amp%3Brs%3Den-gb%26amp%3Bad%3Dgb%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3Ehttps%3A%2F%2Fsupport.microsoft.com%2Fen-gb%2Foffice%2Frefresh-pivottable-data-6d24cece-a038-468a-8176-8b6568ca9be2%3Fui%3Den-us%26amp%3Brs%3Den-gb%26amp%3Bad%3Dgb%3C%2FA%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20would%20be%20happy%20to%20know%20if%20I%20could%20help.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ENikolino%3C%2FP%3E%3CP%3EI%20know%20I%20don't%20know%20anything%20(Socrates)%3C%2FP%3E%3C%2FLINGO-BODY%3E
Contributor

I'd like to make a filter selection and have the title update automatically on my pivot chart. How do I do this? Thanks for any help in advance. So - In the pic below, I'd like to change the filter from "Broccoli" to "Cauliflower" and have the chart title update automatically.Screenshot (56).png

5 Replies

@slohombre 

 

Maybe I can help you with this food for thought.

Refresh PivotTable data

https://support.microsoft.com/en-gb/office/refresh-pivottable-data-6d24cece-a038-468a-8176-8b6568ca9...

 

I would be happy to know if I could help.

 

Nikolino

I know I don't know anything (Socrates)

best response confirmed by slohombre (Contributor)
Solution

@slohombre 

 

You can make chart title dynamic by referencing it to pivot filter value.

To do this select chart title then in formula bar write - (using your example in screenshot)

=B2

 

 

Thanks !

The trick is to type in the "formula bar" instead of "title chart box".