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 f...
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 !
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".