+ Reply to Thread
Results 1 to 7 of 7

Custom Error Bars

  1. #1
    Registered User
    Join Date
    10-03-2009
    Location
    London
    MS-Off Ver
    Excel 2003
    Posts
    5

    Custom Error Bars

    I am trying to insert error bars to my graph but I am having difficulty. The error in the y-axis is the same for all the points in the graph so I was able to do that quite easily. However, the error in the x-axis is different for each inividual point on the graph. Is there a way of entering the error values individually for each point? Do I use the 'custom' setting in the error bar options? But I have not worked out how to use this. I am using excel 2007.

    Thanks for any help.

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

    Re: Help With Custom Error Bars

    See explanation
    http://peltiertech.com/WordPress/err...in-excel-2007/
    Cheers
    Andy
    www.andypope.info

  3. #3
    Registered User
    Join Date
    10-03-2009
    Location
    London
    MS-Off Ver
    Excel 2003
    Posts
    5

    Re: Help With Custom Error Bars

    Thanks for the link. I read through it though I'm still not sure exactly what I'm supposed to do.

    For example I want the x-axis error in the first data point to be plus and minus 0.03, in the second point it should be plus and minus 0.02, in the third point it should be plus and minus 0.05 etc... How do I do that? This is the first time I've attempted this so some detail instructions would be appreciated.

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

    Re: Help With Custom Error Bars

    Not sure how I can explain it any easier. The article has details and pictures.

    You need to have the various error bar values in a range, one value for each data point.
    You then use the Select Custom to select the range for both pos/neg errors.

    If you are still stuck post a workbook

  5. #5
    Registered User
    Join Date
    10-03-2009
    Location
    London
    MS-Off Ver
    Excel 2003
    Posts
    5

    Re: Custom Error Bars

    Ok. Here's my attempt. Vertical error bars are fine sine they have a fixed value. I have entered the horizontal error bar values in column C. In the horizontal error bar options I selected custom and then selected all the error values in column C as the value for both positive and negative error (after deleting the default entry). The error bars however still don't much the values in column C.

    Thanks again.
    Attached Files Attached Files

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

    Re: Custom Error Bars

    Your chart is correct.

    Why do you think the error bars are wrong.
    Take a look at the point I have altered the values on. It appears to align correctly.
    Attached Files Attached Files

  7. #7
    Registered User
    Join Date
    10-03-2009
    Location
    London
    MS-Off Ver
    Excel 2003
    Posts
    5

    Re: Custom Error Bars

    Thanks. I guess I just posted it in a hurry without looking at it too carefully. Also I probably expected it to be wrong because its was my first attempt at doing this.

    Anyway thank you. I now know how it works.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

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