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


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



Maybe I can help you with this food for thought.

Refresh PivotTable data


I would be happy to know if I could help.



I know I don't know anything (Socrates)

best response confirmed by slohombre (Contributor)



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)




Thanks !

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