Hey! Sign in to get help with your study questionsNew here? Join for free to post

Help creating bar chart with error bars/standard deviation?

Announcements Posted on
Last day to win £100 of Amazon vouchers - don't miss out! Take our quick survey to enter 24-10-2016
    • Thread Starter

    Hey everyone, for my biology coursework I need help creating a simple bar chart, but with error bars/standard deviation included. I'm struggling to do this in word/excel and was wondering if anyone could help.

    All I need is two bars, each showing the average change in blood pressure from two groups, one is after liquorice consumption with the other after consumption of a placebo sweet.

    The changes are:
    Liquorice 1.4167
    Placebo 0.583

    I'm not sure how to work out/implement the error bars. Do I need to calculate standard deviation using a formula? Or do I just put on the range difference, i.e. the lowest and highest change, if you get what I mean.

    Any help would be greatly appreciated. Thanks

    What data do you have so far? Is there a requirement somewhere to use SD over range bars? Both are possible but obviously range bars are easier to do. It is entirely possible in Excel! What would be easier is to use a forest plot rather than a bar chart. This would use the value of 1 to be blood pressure of controls (not taking anything), and then the relative increases/decreases in BP after taking the placebo and liquorice around that value. That method also allows you to see if your results are statistically significant: if one of your error bars overlaps 1, then the true effect could actually be nothing.

    If you want to use that method, I know how to make it on Excel and can give you a guide. Otherwise, I can also give you a guide on how to overlay error bars onto a bar chart Let me know!
Write a reply…


Submit reply


Thanks for posting! You just need to create an account in order to submit the post
  1. this can't be left blank
    that username has been taken, please choose another Forgotten your password?
  2. this can't be left blank
    this email is already registered. Forgotten your password?
  3. this can't be left blank

    6 characters or longer with both numbers and letters is safer

  4. this can't be left empty
    your full birthday is required
  1. Oops, you need to agree to our Ts&Cs to register
  2. Slide to join now Processing…

Updated: May 6, 2016
TSR Support Team

We have a brilliant team of more than 60 Support Team members looking after discussions on The Student Room, helping to make it a fun, safe and useful place to hang out.

Would you rather find

The Student Room, Get Revising and Marked by Teachers are trading names of The Student Room Group Ltd.

Register Number: 04666380 (England and Wales), VAT No. 806 8067 22 Registered Office: International House, Queens Road, Brighton, BN1 3XE

Reputation gems: You get these gems as you gain rep from other members for making good contributions and giving helpful advice.