Forum Discussion
Solved
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.
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 !
8 Replies
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 !
- JPMoney You need to make a direct reference to the sheet and cell.
So not just "=B2" but "=Sheet1!$B$2".
And Sheet1 should be the name of the sheet.
- The trick is to type in the "formula bar" instead of "title chart box".
- Very good!
Maybe I can help you with this food for thought.
Refresh PivotTable data
I would be happy to know if I could help.
Nikolino
I know I don't know anything (Socrates)
