+ Reply to Thread
Results 1 to 4 of 4

Macro to Center Titles and Horizontal Axis Labels on All Charts in Sheet

  1. #1
    Registered User
    Join Date
    09-03-2009
    Location
    Red Bank, NJ
    MS-Off Ver
    Excel 2010
    Posts
    55

    Macro to Center Titles and Horizontal Axis Labels on All Charts in Sheet

    I'm trying to create a sub to clean-up the centering of Chart Title and Horizontal Axis Title on all charts in a sheet. The following code works for the Chart Titles:

    Please Login or Register  to view this content.
    I have not been able to find a similar approach that works for the Horizontal Axis Titles, which I'd like centered below the plot area.
    Ideally I'd also like to be able to set the top border of the Chart Title to line up exactly with the top border of the entire chart.

    Any help would be greatly appreciated.

  2. #2
    Registered User
    Join Date
    09-03-2009
    Location
    Red Bank, NJ
    MS-Off Ver
    Excel 2010
    Posts
    55

    Re: Macro to Center Titles and Horizontal Axis Labels on All Charts in Sheet

    I should have added that the titles are linked to cell data which can change in length, hence the need to automate the clean-up of centering.

  3. #3
    Forum Guru Andy Pope's Avatar
    Join Date
    05-10-2004
    Location
    Essex, UK
    MS-Off Ver
    O365
    Posts
    20,419

    Re: Macro to Center Titles and Horizontal Axis Labels on All Charts in Sheet

    If you have xl2010 or newer this should work.

    Please Login or Register  to view this content.
    Cheers
    Andy
    www.andypope.info

  4. #4
    Registered User
    Join Date
    09-03-2009
    Location
    Red Bank, NJ
    MS-Off Ver
    Excel 2010
    Posts
    55

    Re: Macro to Center Titles and Horizontal Axis Labels on All Charts in Sheet

    Andy,

    That worked perfectly. Thank you.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Excel dropping titles, axis labels when printing chart
    By uptix in forum Excel Formulas & Functions
    Replies: 11
    Last Post: 10-29-2013, 04:20 PM
  2. Add labels/titles to vertical axis of scatter chart
    By verwater in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 05-23-2013, 07:19 PM
  3. Horizontal axis labels in Bar Charts
    By jeskit in forum Excel General
    Replies: 2
    Last Post: 08-15-2011, 04:39 AM
  4. Formatting Horizontal Axis Titles
    By lindsayboxer in forum Excel - New Users/Basics
    Replies: 5
    Last Post: 03-30-2011, 05:31 AM
  5. Charts' titles and labels - Font size
    By Myriam in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 04-01-2005, 02:06 AM

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1