+ Reply to Thread
Results 1 to 2 of 2

Custom multi-level label on X-Axis

  1. #1
    Registered User
    Join Date
    03-17-2014
    Location
    London, UK
    MS-Off Ver
    Excel 2010
    Posts
    26

    Custom multi-level label on X-Axis

    Hello all,

    I was wondering if there was a way to edit a chart's Series formula to get multi-level labels on the X axis.

    For example, the formula:

    =SERIES('Charts'!$A$7,{"USA","Italy"},('Charts'!$F$7,'Charts'!$H$7),1)

    Will show two labels, USA and Italy

    My question is if there's a way to use {"USA","Italy"} for multi-level labelling, so that it would show something like:

    USA - Population ; GDP
    Italy - Population ; GDP.

    I hope that makes sense? Big thanks in advance!

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

    Re: Custom multi-level label on X-Axis

    If you use a static array then true multi level lableling will be lost.

    You can add line feeds (ALT+ENTER) in the formula to force text on to the next line.

    =SERIES(,{"USA - Population
    GDP","Italy - Population
    GDP"},Sheet1!$F$14:$G$14,1)
    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)

Similar Threads

  1. Excel chart with multi level category label issue delinking source data from chart
    By babu324 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 12-19-2017, 02:58 AM
  2. [SOLVED] Multi-level Clustered Stacked Chart - Axis
    By Cortlyn in forum Excel Charting & Pivots
    Replies: 4
    Last Post: 05-27-2017, 06:12 AM
  3. [SOLVED] excel chart multi level axis remove separators
    By Vladimir.Yanakiev in forum Excel Charting & Pivots
    Replies: 4
    Last Post: 10-18-2016, 05:34 AM
  4. Managing Multi level X axis
    By aneesh_kotwal in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 09-14-2013, 12:27 AM
  5. Graph X axis (multi-level category labels) not showing all the text
    By mclhone in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 06-05-2013, 09:33 PM
  6. formatting a multi-level catagory axis label???
    By nmoore5 in forum Excel Charting & Pivots
    Replies: 5
    Last Post: 04-17-2013, 03:04 AM
  7. How to adjust higher level of axis label
    By vietdieu in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 03-16-2013, 08:33 AM

Tags for this Thread

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