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 !
- 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.Ghansenrietje Thanks I will give this a try - thanks for responding! JP
