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,
Subscribe to our Windows Secrets Newsletter - It's Free!
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 79 Times in 75 Posts
ActiveChart.ChartTitle.HorizontalAlignment = xlHAlignCenterRegards,
Microsoft MVP - Excel.