2014-05-14, 16:15 #1
- Join Date
- Sep 2002
- Honolulu, Hawaii, USA
- Thanked 0 Times in 0 Posts
Resetting Excel chart's title or axis-label alignment back to centered
Is it possible to re-set the alignment of an Excel chart's title or axis label back to centered? These items are centered initially -- but once one manually resizes or moves such an item, it is no longer centered. If this is possible, what is the syntax for re-centering a chart title?
Mahalo for your help,
Get our unique weekly Newsletter with tips and techniques, how to's and critical updates on Windows 7, Windows 8, Windows XP, Firefox, Internet Explorer, Google, etc. Join our 480,000 subscribers!
+ Get this BONUS — free!
Get the most of Excel! Learn about new features, basics of creating a new spreadsheet and using the infamous Ribbon in the first chapter of Excel 2013: The Missing Manual - Subscribe and download Chapter 1 for free!
2014-05-21, 06:14 #2
- Join Date
- Dec 2000
- Burwash, East Sussex, United Kingdom
- Thanked 84 Times in 80 Posts
ActiveChart.ChartTitle.HorizontalAlignment = xlHAlignCenterRegards,
Microsoft MVP - Excel.