+ Reply to Thread
Results 1 to 4 of 4

Bring Data Labels to Front (of axis)

  1. #1
    Registered User
    Join Date
    06-20-2018
    Location
    New Jersey
    MS-Off Ver
    365
    Posts
    6

    Bring Data Labels to Front (of axis)

    Hello,

    I created a custom data label series using "Value From Cells" to have a label at the end of the chart displaying the current value. Unfortunately, the axis labels are "on top"/"in front" of the data label. Is there any way to change this (VBA or otherwise)? Thanks!

    Screen Shot 12-14-18 at 04.15 PM.PNG

  2. #2
    Forum Moderator - RIP Richard Buttrey's Avatar
    Join Date
    01-14-2008
    Location
    Stockton Heath, Cheshire, UK
    MS-Off Ver
    Office 365, Excel for Windows 2010 & Excel for Mac
    Posts
    29,464

    Re: Bring Data Labels to Front (of axis)

    Are you able to upload the workbook so that we may see the request in context?
    Richard Buttrey

    RIP - d. 06/10/2022

    If any of the responses have helped then please consider rating them by clicking the small star icon below the post.

  3. #3
    Registered User
    Join Date
    06-20-2018
    Location
    New Jersey
    MS-Off Ver
    365
    Posts
    6

    Re: Bring Data Labels to Front (of axis)

    Thanks Richard- I just came up with a pain in the butt workaround. I'll do my best to explain it here in case anyone else comes across this.

    To make this easier, the point I want the data label for will be called A. This is the latest value of the original series that should be labeled off to the right of the chart.
    1. I removed the old data labels.
    2. I created a scatter plot with one point: (0,y). The y value was set to A as a percentage of the minimum to maximum y-axis range. So if A is 3 and the y-axis range is -2 to 10, then the y-value would be 3/(10 - -2) = 3/12 = .25. So the result would be a scatter plot with one point at (0,.25).
    3. I made everything on the scatter plot chart (e.g. plot area) invisible EXCEPT the one scatter plot point. This gives me a floating scatter point that moves up and down the y-axis, depending on the percentage calculated above.
    4. I added a y-axis to the scatter plot, and set the minimum to 0 and the maximum to 1. I then removed the axis. This was only to set that min/max.
    5. I moved my scatter plot so that the top/bottom of the plot area was exactly even with the top/bottom of the plot area of my original chart. So now, I have a single point that is moving up and down along the height of the original chart's plot area. Its up/down position is determined by A, and it will line up exactly with the y-position of A (because that's how I designed it).
    6. I added a data label to the scatter plot and hid the scatter plot series. So now, I have my data label in the correct up/down position (lined up with the A).
    7. Change the data label "Label Options" --> "Label Contains" to "Value From Cells". Then reference a cell with A's value that we want displayed (instead of the % value we used to get the up/down position right).
    8. Last step is just to move the scatter plot left/right until it's in the perfect spot to the right of the plot area, and done!

    Then repeat that miserable process for 16 charts with copy/paste when possible. Hope this helps someone else!

    Screen Shot 12-14-18 at 09.06 PM.PNG

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

    Re: Bring Data Labels to Front (of axis)

    Did you try creating the axis labels with another dummy series?
    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. Replies: 2
    Last Post: 10-30-2015, 02:56 PM
  2. [SOLVED] Need graph to show alphanumeric values as Y axis labels with Date as Z axis labels
    By Ochimus in forum Excel Charting & Pivots
    Replies: 4
    Last Post: 06-24-2015, 08:40 PM
  3. Replies: 2
    Last Post: 06-25-2013, 12:43 PM
  4. How to bring header to front?
    By adds007 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 06-25-2010, 12:55 PM
  5. Adding in Front and Bring Together
    By textboom in forum Excel General
    Replies: 5
    Last Post: 09-08-2008, 04:13 PM
  6. [SOLVED] How do I bring a certain data series to the front
    By Adam P. in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 01-03-2006, 04:40 PM
  7. "Bring to Front" Data Labels?
    By Rob in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 04-03-2005, 12:06 PM

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