Excel.Tips.Net: Using Dynamic Chart Titles
July 05, 2012 by Excel Tips in Excel Tips
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.
Article Continued Here
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.)
Loading ...
Rob Cheng
Steve Hogan
Lyle Schuknecht
Steve Bass
Harry McCracken
Chris Pirillo
Bill Pytlovany
John Dodge
Leo Notenboom
Bob Rankin
Windows Secrets
GFI VIPRE
Windows Talk
Powerpoint Tips
Techlicious
Make Tech Easier
Dave's Computer Tips
Burn World
Excel Tips
Windows Observer
Ask Dave Taylor
Word Tips
Tips4PC
Windows Club
Windows Guides
PCTechBytes
Everything Microsoft
Terry Stockdale
I use Excel 2010 and toward the end of 2011 portions of the spreadsheet stopped working. The data was valid & the formulas were correct, but the spreadsheet would not calculate any of the formulas. I loaded the spreadsheet onto another computer & the calculation function resumed working. I then reloaded the working spreadsheet back on my existing computer and it now works ok. What happened?