By Allen Wyatt for Excel.Tips.Net
Using Dynamic Chart Titles
There is a very cool way, apparently not well known, of adding ‘active’ or ‘live’ titles and other text to charts. In this way you can make a change in a worksheet and have that change reflected in a title in the chart. Follow these steps:
1. Create your chart as you normally would.
2. Add whatever titles, datapoints, axis names, etc. are desired.
3. Select the title you want to modify. Small handles should appear around the title.