+ Reply to Thread
Results 1 to 4 of 4

Reverse Overlay Order of Chart Labels

  1. #1
    Registered User
    Join Date
    10-21-2016
    Location
    Kansas City, MO
    MS-Off Ver
    2010, 2013
    Posts
    75

    Reverse Overlay Order of Chart Labels

    Am trying to compare last year's numbers to this year's numbers by week in a chart - blue bar with black label is this year and red bar with yellow label is last year. Excel defaults to positioning the yellow labels in front of the black labels, and I cannot find any setting or alignment option to change this. I am wanting the black label to lead so that in instances of the attached picture this year's number is never obscured. Can you please advise? Would be great if you could word-wrap behind/in front of text with labels but not finding a way to do so and most of my Format Data Labels > Alignment tab is greyed out.
    Attached Images Attached Images

  2. #2
    Forum Expert CK76's Avatar
    Join Date
    06-16-2015
    Location
    ONT, Canada
    MS-Off Ver
    Office 365 ProPlus
    Posts
    5,883

    Re: Reverse Overlay Order of Chart Labels

    AFAIK, data label of left series will be on top of right. And there is not way to adjust.

    Try changing series order and see what happens.

    But in general, I'd advise against overlapping data labels. Use size adjustment and/or VBA code to adjust position to avoid overlap.
    As it makes it harder to read and detracts from visual.
    ?Progress isn't made by early risers. It's made by lazy men trying to find easier ways to do something.?
    ― Robert A. Heinlein

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

    Re: Reverse Overlay Order of Chart Labels

    You could use custom number formats to add non breaking spaces to front and end of value in order to move them apart.

    In 2016 you have more control over the data labels so you can adjust the right and left margins
    Cheers
    Andy
    www.andypope.info

  4. #4
    Registered User
    Join Date
    10-21-2016
    Location
    Kansas City, MO
    MS-Off Ver
    2010, 2013
    Posts
    75

    Re: Reverse Overlay Order of Chart Labels

    Thanks, CK76 and Andy Pope - my bars get pretty narrow (52 weeks), but I will see what I can do.

+ 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. [SOLVED] Timeline Gantt chart - Chart bars are in reverse order
    By gan_xl in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 03-20-2019, 01:02 PM
  2. Chart data table in reverse order
    By bleepy in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 11-18-2013, 05:18 AM
  3. Reverse order of coloring on a bar chart
    By kekachur in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 06-11-2013, 12:58 PM
  4. Chart Legend appears in Reverse Order
    By Guido Meng in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 02-13-2013, 08:13 PM
  5. Stacked Bar Chart columns are in reverse order
    By twfry in forum Excel General
    Replies: 6
    Last Post: 03-14-2011, 04:43 AM
  6. Reverse order of bar chart
    By Jeanne in forum Excel Charting & Pivots
    Replies: 6
    Last Post: 11-03-2009, 04:21 PM
  7. [SOLVED] hierarchical axis labels reverse chart
    By steve in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 02-07-2006, 04:15 PM

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