+ Reply to Thread
Results 1 to 4 of 4

Trouble with Error bars

  1. #1
    Registered User
    Join Date
    05-05-2015
    Location
    California
    MS-Off Ver
    2007/2013
    Posts
    3

    Exclamation Trouble with Error bars

    I am trying to add custom error bars to my line chart. I have 5 different series, for each of the first four series I have been able to add the error bars onto the graph. I have tried for hours to figure out how to get the error bars on this particular series. If I have it put in any type of error bars without changing the numbers, it will put them. As soon as I customize the numbers the bars disappear. Please help! This is for my thesis due next week!
    Book3.xlsx

  2. #2
    Forum Guru
    Join Date
    04-13-2005
    Location
    North America
    MS-Off Ver
    2002/XP and 2007
    Posts
    15,802

    Re: Trouble with Error bars

    I did not have any trouble adding the error bars, and since you didn't leave your error bar definition in place for the 5th series, I do not know what you did wrong. My guess:

    1) For series 1, 3, and 4, you selected only one cell for the error bar values. Excel assigns this error value to the error bars for each point, including the "blank" points.
    2) For series 2, you use the entire error range E2:E6, which includes the "blank" error for the "blank" point in D2.
    3) My guess is that, when you went to assign the values to the error bars in series 5, you did not include the blanks K2:K8, but started immediately in K9. Since the series definition starts in row 2 (J2:J11), if you only select K9:K11 for the error bar values, it assumes that those error values pertain to the first three points of the series, which would be the blank J2:J4. I expect that, what you need to do, is select the entire column K2:K11 for the error bar values (to correspond with the J2:J11 that defines the series).

    See if that helps.
    Quote Originally Posted by shg
    Mathematics is the native language of the natural world. Just trying to become literate.

  3. #3
    Registered User
    Join Date
    05-05-2015
    Location
    California
    MS-Off Ver
    2007/2013
    Posts
    3

    Exclamation Re: Trouble with Error bars

    Thank you for your answer. Let me upload the version I have the error bars added (sorry, I have deleted and re-added it so many times I didn't even think to make sure they were there. If at all possible, aside from letting me know what is wrong, I maybe get it returned back to me with the error bars in place? I need this for me thesis due next week and have already spent enough time trying to figure it out. Thanks!
    Book3.xlsx

  4. #4
    Registered User
    Join Date
    05-05-2015
    Location
    California
    MS-Off Ver
    2007/2013
    Posts
    3

    Re: Trouble with Error bars

    Never mind! I figured out what you meant! Got it! Thanks soooo much!

+ 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. Trouble with Data Bars
    By tahuhali in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 04-09-2014, 03:56 PM
  2. Replies: 2
    Last Post: 03-28-2012, 02:29 PM
  3. Range bars, not error bars
    By Anselm in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 11-14-2010, 12:38 AM
  4. Error bars
    By topazo in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 08-27-2009, 04:32 AM
  5. chart: error bars with custom error range
    By brickc1 in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 03-26-2009, 11:52 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