Only 150 people in the world prefer static to dynamic chart titles.
This Excel Q&A by Philip Gamey will show you how to create dynamic chart titles for your pivot charts.
Below is the video from the ExcelMonster YouTube page:
E-mail: info(at)excelmonster.com