Results 1 to 2 of 2
  1. #1
    Star Lounger
    Join Date
    Sep 2002
    Location
    Honolulu, Hawaii, USA
    Posts
    63
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Question Resetting Excel chart's title or axis-label alignment back to centered

    Aloha folks,

    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,

    John Jacobson

  2. #2
    WS Lounge VIP rory's Avatar
    Join Date
    Dec 2000
    Location
    Burwash, East Sussex, United Kingdom
    Posts
    5,938
    Thanks
    0
    Thanked 94 Times in 90 Posts
    For example:
    Code:
        ActiveChart.ChartTitle.HorizontalAlignment = xlHAlignCenter
    Regards,
    Rory
    Microsoft MVP - Excel.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •