+ Reply to Thread
Results 1 to 4 of 4

Alignment of numbers beneath columns

  1. #1
    Registered User
    Join Date
    12-02-2012
    Location
    College Station, TX
    MS-Off Ver
    Excel 2010
    Posts
    2

    Question Alignment of numbers beneath columns

    Hey all,

    I'm having a problem making a fairly simple column chart, and I'm hoping I'm missing an obvious fix to this issue. Basically, I've got a simple Clustered Column chart, with 5 columns shown. Each column is supposed to represent data collected in 2 hour increments (i.e. a column for 2 a.m. to 4 a.m., a column for 4 a.m. to 6 a.m., etc.). Thus, I'd like for the numbers on the x-axis to be below the left side of each column; however, I can't find a way to move the corresponding numbers to anywhere except dead center beneath the columns. Can anyone provide some insight on how to get around this?

    I've attached a screenshot in case my description was a bit confusing. I want the numbers beneath the x-axis (2, 4, 6, 8) to appear below the left-most side of each column, instead of their current position below the center of each column.

    Any help would be greatly appreciated! Thanks!
    Attached Images Attached Images

  2. #2
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 2000/3/7/10/13/16
    Posts
    51,311

    Re: Alignment of numbers beneath columns

    It would be far better if you could upload a workbook sample, pictures are impossible to work with, and some1 may just send you a picture back of the solution
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford

  3. #3
    Registered User
    Join Date
    12-02-2012
    Location
    College Station, TX
    MS-Off Ver
    Excel 2010
    Posts
    2

    Re: Alignment of numbers beneath columns

    Sounds good, here's the sample workbook. Thanks!
    Attached Files Attached Files

  4. #4
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 2000/3/7/10/13/16
    Posts
    51,311

    Re: Alignment of numbers beneath columns

    sorry for the delay in replying

    if you click on the x-axis labels, you can change the alignment of the values. you can use the same buttons on the home tab under alignment, see if 1 of those gives you what you need?

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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