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.
About Excel Tips
The tips and ideas from ExcelRibbon.Tips.Net are designed specifically for users of Excel starting with Excel 2007. You'll find just about everything you need to become productive with the program right away. (If you need help with other versions of Excel, visit the ExcelTips site.)