+ Reply to Thread
Results 1 to 5 of 5

Displaying labels for error bars only

  1. #1
    Valued Forum Contributor
    Join Date
    02-09-2006
    Location
    Melbourne, Australia
    MS-Off Ver
    Office 2016
    Posts
    1,075

    Displaying labels for error bars only

    I received awesome help in another thread to include the custom error bars in the attached chart. Now I want to add data labels but ONLY for the error bars. Is this possible?

    Thanks again for your time.
    Attached Files Attached Files
    Trish in Oz
    -------------
    A problem well defined is a puzzle half solved


    If you attach a sample of your workbook it will be easier to find a solution. Remember to remove/replace sensitive data before uploading the file. Look here if you need help with attachments:
    http://www.excelforum.com/faq.php?fa...b3_attachments

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

    Re: Displaying labels for error bars only

    Add another series to the chart that only has values for the points where the error bars are. It's unclear what value you want to show, so you may need to modify the data label so it shows a value from a cell rather than it's actual value.
    Cheers
    Andy
    www.andypope.info

  3. #3
    Valued Forum Contributor
    Join Date
    02-09-2006
    Location
    Melbourne, Australia
    MS-Off Ver
    Office 2016
    Posts
    1,075

    Re: Displaying labels for error bars only

    Thanks for your help Andy. I have added text box labels to the new attachment so you can see what the end result needs to be. I hope this makes it clearer.

    I tried a secondary axis but I cannot make the arrows align correctly in between the two rows of data the same way that the error bars do.
    Attached Files Attached Files

  4. #4
    Forum Guru xlnitwit's Avatar
    Join Date
    06-27-2016
    Location
    London
    MS-Off Ver
    Windows: 2010; Mac: 16.13 (O365)
    Posts
    7,085

    Re: Displaying labels for error bars only

    Hi,

    I believe this is what Andy was talking about. The added series is used for the data labels, which are linked to the cells, and the error bars are drawn from the actual data.
    Attached Files Attached Files
    Don
    Please remember to mark your thread 'Solved' when appropriate.

  5. #5
    Valued Forum Contributor
    Join Date
    02-09-2006
    Location
    Melbourne, Australia
    MS-Off Ver
    Office 2016
    Posts
    1,075

    Re: Displaying labels for error bars only

    Thanks a lot D. I need to absorb how this works.

+ 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. Individual Error Bars not displaying correctly- Excel 2013
    By DAWCAC in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 06-05-2016, 07:02 PM
  2. Distance between bars & data labels
    By GL_1007 in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 06-17-2015, 09:18 PM
  3. [SOLVED] How do I add axis labels to bar chart bars?
    By worthm in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 02-09-2015, 05:18 PM
  4. Error bars displaying the range
    By mike_88 in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 01-02-2012, 07:23 PM
  5. Range bars, not error bars
    By Anselm in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 11-14-2010, 12:38 AM
  6. [SOLVED] Inserting labels and bars
    By rulerz in forum Excel General
    Replies: 0
    Last Post: 07-27-2006, 07:10 PM
  7. [SOLVED] Error bars not displaying
    By [email protected] in forum Excel General
    Replies: 1
    Last Post: 12-07-2005, 04:15 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