+ Reply to Thread
Results 1 to 6 of 6

Axis Graph Labeling

  1. #1
    Registered User
    Join Date
    02-14-2011
    Location
    Detroit, MI
    MS-Off Ver
    Excel 2007
    Posts
    50

    Axis Graph Labeling

    Hi,
    I have attached a dummy workbook to help explain my current issue. I want my horizontal axis to show both the Wk and Date. I have tried doing different things but can only get one or the other not both. Does anyone know how I can change it so both rows show up as my Horizontal axis?

    Thanks,
    John
    Attached Files Attached Files

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

    Re: Axis Graph Labeling

    The hidden row is causing a problem.

    Build the required labels in a single row using formula.

    =D1&CHAR(10)&D3

    Then update chart series to use new single row.
    Cheers
    Andy
    www.andypope.info

  3. #3
    Registered User
    Join Date
    02-14-2011
    Location
    Detroit, MI
    MS-Off Ver
    Excel 2007
    Posts
    50

    Re: Axis Graph Labeling

    Andy,
    Thanks for the response but I am still have an issue. Sorry I left that row hidden the rows are:

    1 - Week
    2- Month
    3- Day

    I just want the graph to show the Wk and the Day for example I want the chart to state the following for Column D.


    Wk 1 - 1/3 This is exactly what I want the axis to say for the first point on the chart. Can I do this?

    Thanks,
    John

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

    Re: Axis Graph Labeling

    Slight mod to formula to output date from row 3 correctly.

    =D1&CHAR(10)&TEXT(D3,"m/d")
    Attached Files Attached Files

  5. #5
    Registered User
    Join Date
    02-14-2011
    Location
    Detroit, MI
    MS-Off Ver
    Excel 2007
    Posts
    50

    Re: Axis Graph Labeling

    Thanks for your help. I can get it to work now but I think the text string is too long and it still isnt showing both on the chart axis text. Is there some format thing I have to change also?

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

    Re: Axis Graph Labeling

    Did you turn of the -90 degree alignment and just have the labels horizontal?

    You will also need to set the tick interval to 1 instead of 4 if you want every axis label shown.

+ 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