+ Reply to Thread
Results 1 to 2 of 2

How to create multiple x-axis labels?

  1. #1
    Registered User
    Join Date
    11-29-2013
    Location
    Stanford, CA
    MS-Off Ver
    Excel 2003
    Posts
    1

    How to create multiple x-axis labels?

    Right now I have this:

    Screen Shot 2013-11-29 at 1.02.47 PM.jpg

    How can I put another label under each bar (NOT outside end or inside end or any additional label. This is an actual label? For example, under the first blue bar labeled 56.7%, I also want to put N = 50 below the X-axis, above "Optimal." I also want to put N = 25 for the red bar immediately next to it labeled at 75.7%.

    This is not a label, as it is below the X-axis.

    An example of this can be found here (scroll down for second chart)

    Thank you!

    http://link.springer.com/article/10..../fulltext.html

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

    Re: How to create multiple x-axis labels?

    You can use 2 additional series and put them on the secondary axis.
    The use their data labels linked to cells to display the base sizes.

    Use a custom number format to hide the negative % axis values.
    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)

Similar Threads

  1. Multiple x-axis labels on a single bar chart
    By JamesForeman in forum Excel General
    Replies: 4
    Last Post: 11-09-2012, 12:27 PM
  2. [SOLVED] Can't link category (X) axis labels to multiple series in column chart, arrgh
    By danob in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 08-05-2012, 10:03 AM
  3. Multiple X and Y Axis labels
    By sdubose99 in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 08-07-2006, 12:14 AM
  4. [SOLVED] multiple x axis labels
    By Mwise in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 08-04-2006, 03:10 PM
  5. [SOLVED] how to put x axis values in the chart instead of x axis labels
    By Sinclair in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 06-21-2005, 06:05 AM

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