Results 1 to 8 of 8
  1. #1
    New Lounger
    Join Date
    May 2007
    Posts
    1
    Thanks
    0
    Thanked 0 Times in 0 Posts

    error bars and standard deviation (2003)

    hey, ive got a bar chart and i want to add an error bar to each bar to reflect its standard deviation. but at the moment excel will only let me change all of the bars so that the error bars are all the same for every bar in my chart. how do i do each one seperately? and which option do i choose so that i can type in the particular standard deviation for a particular bar?
    thanks,
    emily

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: error bars and standard deviation (2003)

    Welcome to Woody's Lounge!

    You should create an extra column (or row) in your data table for the errors; this column can be entered manually or contain formulas.
    Select a series in the chart.
    Select Format | Selected Series...
    Activate the Error Bars tab.
    Click Custom, and point to the column with the errors for both the positive and negative errors (assuming thst you want them to be equal)
    Click OK.

    See the attached example.
    Attached Files Attached Files

  3. #3
    3 Star Lounger
    Join Date
    Apr 2004
    Location
    Albuquerque, New Mexico, USA
    Posts
    233
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: error bars and standard deviation (2003)

    Hans,

    When I try to change the Y Error Bars on your example workbook, Plus, Minus, and None work, but Both only shows the Plus error bar, not the Minus. How do I get Both Y Error Bars to show? Most peculiar, since the Minus ones show just fine when Minus is selected. (The Format Data Series > Y Error Bars > Error Amount > Custom plus and minus boxes both have the error range of =Sheet!$B$2:$B$6.)

  4. #4
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: error bars and standard deviation (2003)

    I have attached a screenshot of what the chart looks like on my PC. Both the plus and minus error bars are clearly visible. <img src=/S/scratch.gif border=0 alt=scratch width=25 height=29>
    Attached Images Attached Images
    • File Type: png x.png (1.4 KB, 4 views)

  5. #5
    3 Star Lounger
    Join Date
    Apr 2004
    Location
    Albuquerque, New Mexico, USA
    Posts
    233
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: error bars and standard deviation (2003)

    In my Excel 2003 SP2, it looks like the attachment, only plus bars:
    Attached Images Attached Images

  6. #6
    4 Star Lounger
    Join Date
    Feb 2006
    Location
    Cape Cod, Massachusetts, USA
    Posts
    408
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: error bars and standard deviation (2003)

    Click on the Patterns tab and make sure the marker with the horizontal element is selected.

    Paul

  7. #7
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: error bars and standard deviation (2003)

    Both the plus and minus error bars are clearly visible in your screenshot <img src=/S/scratch.gif border=0 alt=scratch width=25 height=29>
    Only the plus bars have a narrow cross bar at the top, the minus bars don't. That's probably a formatting problem, as Paul (Ledunch) suggests. Double click the minus bars to format them.

  8. #8
    3 Star Lounger
    Join Date
    Apr 2004
    Location
    Albuquerque, New Mexico, USA
    Posts
    233
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: error bars and standard deviation (2003)

    Paul and Hans: Your suggestion fixed the error crossbars. Thank you both.

    Hans, I apologize for mis-speaking (or mis-typing): Instead of "error bars" I should have said "the little horizontal cross bar gizmo at the ends of the error bars". "That" is what was missing initially.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •