Forum Discussion

slohombre's avatar
slohombre
Copper Contributor
Sep 30, 2020
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...
excel
  • lifeofgaurav's avatar
    lifeofgaurav
    Sep 30, 2020

    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 !

Resources