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

[slohombre]

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.

[#2]

@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)

[#3 · Accepted 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 !

[#4]

@lifeofgaurav Thank you! That did the trick!

[#5]

Very good!

[#6]

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