+ Reply to Thread
Results 1 to 4 of 4

Multi-Level Category Labels

  1. #1
    Registered User
    Join Date
    04-30-2009
    Location
    Provo, Utah
    MS-Off Ver
    Excel 2007
    Posts
    19

    Multi-Level Category Labels

    I am making a Gantt chart in Excell, and I need to have a few different fields included in the axis labels.
    I first tried to use the Multi-Level Category Labels, but apparently there is no way to make the text to align horizontally.
    Then I tried to combine all the desired columns into one 'label' column, but I have the problem that the values don't line up in columns anymore, but varry according to the lengths of the words.

    This will all make more sense when you view the sample workbook.

    I need to have all those values show up in columns on the axis labels. I don't care how I do it.

    I am proficient with VBA, so that might have a good option.
    Thanks in advance.

    PS, while we're at it, is there any way to bold certain axis labels based on the first few characters of the Project Name?
    Attached Files Attached Files
    Last edited by great.bean; 01-21-2010 at 04:59 PM.

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

    Re: Multi-Level Category Labels

    One way would be to use both vertical axes.
    Add another series and move it to the secondary axis.

    On the left display Name and Project. On the right display the monetary values.

    Formatting of axis applies to all items.
    You might be able to use data labels to replace axis labels.
    Attached Files Attached Files
    Cheers
    Andy
    www.andypope.info

  3. #3
    Registered User
    Join Date
    04-30-2009
    Location
    Provo, Utah
    MS-Off Ver
    Excel 2007
    Posts
    19

    Re: Multi-Level Category Labels

    Andy,
    Thanks for the help. Than Gantt chart looks really nice!! I will use that as a template from now on.

    I also found a way to make the columns stay aligned:

    I created a label column that had a formula like this in it:

    =A1 & REPT(" ",(16-LEN(A1))) & B1 & REPT(" ",(80-LEN(B1))) & C1 & REPT(" ",9-LEN(C1)) & D1 & REPT(" ",7-LEN(D1))

    This makes it so each 'column' in the axis label is a certain number of characters wide. I had to use a courier font for the axis label, which is less than ideal, but it worked.

    Thanks alot!

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

    Re: Multi-Level Category Labels

    You might find Lucida Console more appealing.

+ 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