+ Reply to Thread
Results 1 to 2 of 2

How to adjust higher level of axis label

  1. #1
    Registered User
    Join Date
    01-13-2012
    Location
    SLD
    MS-Off Ver
    Excel 2010
    Posts
    73

    How to adjust higher level of axis label

    Hi charts expert,
    Surely you know that we can have Multi-level axis label (ex: Year/Quarter/Month) but Excel seem just allow us to adjust text alignment/text size/text color for the last level. Is that really true or we can have another way to mess with higher level?
    Thank you for your help.
    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,485

    Re: How to adjust higher level of axis label

    Unfortunately you can only format the inner level of labels.

    You can fake the axis by using the secondary axis.

    I have left the axis and series formatting in place so you can see how it's constructed.
    Attached Files Attached Files
    Cheers
    Andy
    www.andypope.info

+ 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