Hey there! Sign in to join this conversationNew here? Join for free
    • Thread Starter
    Offline

    18
    ReputationRep:
    http://prntscr.com/ac3blr

    confused :cry2:
    Offline

    17
    ReputationRep:
    Pickle
    • Thread Starter
    Offline

    18
    ReputationRep:
    (Original post by TheonlyMrsHolmes)
    Pickle
    Are you asking to be beaten with a fish?
    Offline

    17
    ReputationRep:
    (Original post by bluemadhatter)
    Are you asking to be beaten with a fish?
    :loveduck:
    Offline

    16
    ReputationRep:
    Spoiler:
    Show
    1. On 2-D area, bar, column, line, xy (scatter), or bubble chart, do one of the following:
      • To add error bars to all data series in the chart, click the chart area.
      • To add error bars to a selected data point or data series, click the data point or data series that you want, or do the following to select it from a list of chart elements:
      • Click anywhere in the chart.This displays the Chart Tools, adding the Design, Layout, and Format tabs.
      • On the Format tab, in the Current Selection group, click the arrow next to the Chart Elements box, and then click the chart element that you want.
    2. On the Layout tab, in the Analysis group, click Error Bars.
    3. Do one of the following:
      1. Click a predefined error bar option, such as Error Bars with Standard Error, Error Bars with Percentage, orError Bars with Standard Deviation.
      2. Click More Error Bar Options, and then under Vertical Error Bars or Horizontal Error Bars, click the display and error amount options that you want to use.NOTE The direction of the error bars depends on the chart type of your chart. For scatter charts, both horizontal and vertical error bars are displayed by default. You can remove either of these error bars by selecting them, and then pressing DELETE.

    From the Microsoft Office website, Idk if this makes any sense to you I have very little experience with excel
    Offline

    17
    ReputationRep:
    https://support.office.com/en-us/art...5-864049a145f0
    • TSR Support Team
    • Clearing and Applications Advisor
    Offline

    21
    ReputationRep:
    TSR Support Team
    Clearing and Applications Advisor
    (Original post by bluemadhatter)
    http://prntscr.com/ac3blr

    confused :cry2:
    If this is a new version of Office, with the chart selected, click on the "Design" tab under the "Chart tools" section of the ribbon, then click "add chart element" (on the left hand side of the screen) and then click "error bars". If your errors are absolute then click "standard error", if it's percentage then click "percentage error". Error bars will then appear. To modify them, right click on them in the chart and press "Format error bars". You can then ether apply a fixed absolute error to all, a fixed percentage to all, or you can apply a custom absolute error to each by clicking on "Custom" and then "Specify value". Type in the +/- absolute errors next to your data series in excel, then select the range of values and it'll automatically apply that.
    • Thread Starter
    Offline

    18
    ReputationRep:
    (Original post by Plagioclase)
    If this is a new version of Office, with the chart selected, click on the "Design" tab under the "Chart tools" section of the ribbon, then click "add chart element" (on the left hand side of the screen) and then click "error bars". If your errors are absolute then click "standard error", if it's percentage then click "percentage error". Error bars will then appear. To modify them, right click on them in the chart and press "Format error bars". You can then ether apply a fixed absolute error to all, a fixed percentage to all, or you can apply a custom absolute error to each by clicking on "Custom" and then "Specify value". Type in the +/- absolute errors next to your data series in excel, then select the range of values and it'll automatically apply that.
    Sorry I meant range bars, is it the same thing though??
    • TSR Support Team
    • Clearing and Applications Advisor
    Offline

    21
    ReputationRep:
    TSR Support Team
    Clearing and Applications Advisor
    (Original post by bluemadhatter)
    Sorry I meant range bars, is it the same thing though??
    Yep same thing! So for each of "dark" and "light", you need to basically calculate the difference between the value you've used and the maximum, and the value you've used and the minimum.

    Look at this...



    So here, the Minimum and Maximum columns are the actual minimum and maximum (i.e. the range), the "Min" column is mean-min and the "Max" column is max-mean. You want to do Add Chart Element > Error Bars > Standard error, right click on the bars and press format error bars, select custom and then specify value. Then under the Positive Error Value, select the "min" column and for the Negative error value, select the "max" column (click the little button next to "positive error value" and then click and drag).
    • Thread Starter
    Offline

    18
    ReputationRep:
    (Original post by Plagioclase)
    Yep same thing! So for each of "dark" and "light", you need to basically calculate the difference between the value you've used and the maximum, and the value you've used and the minimum.

    Look at this...



    So here, the Minimum and Maximum columns are the actual minimum and maximum (i.e. the range), the "Min" column is mean-min and the "Max" column is max-mean. You want to do Add Chart Element > Error Bars > Standard error, right click on the bars and press format error bars, select custom and then specify value. Then under the Positive Error Value, select the "min" column and for the Negative error value, select the "max" column (click the little button next to "positive error value" and then click and drag).
    http://prntscr.com/ac3nwk

    it doesn't have add chart element ??
    • TSR Support Team
    • Clearing and Applications Advisor
    Offline

    21
    ReputationRep:
    TSR Support Team
    Clearing and Applications Advisor
    (Original post by bluemadhatter)
    http://prntscr.com/ac3nwk

    it doesn't have add chart element ??
    Okay I think your version is a bit different, have a look at this....
    Should be the same process once you've managed to actually add the error bars.
    • Thread Starter
    Offline

    18
    ReputationRep:
    (Original post by Plagioclase)
    Okay I think your version is a bit different, have a look at this....
    Should be the same process once you've managed to actually add the error bars.
    http://prntscr.com/ac3sz0
    http://prntscr.com/ac3t46

    did I format the minimum and maximum column wrong...

    IDK :cry2:
    • TSR Support Team
    • Clearing and Applications Advisor
    Offline

    21
    ReputationRep:
    TSR Support Team
    Clearing and Applications Advisor
    (Original post by bluemadhatter)
    http://prntscr.com/ac3sz0
    http://prntscr.com/ac3t46

    did I format the minimum and maximum column wrong...

    IDK :cry2:
    Okay well you've managed to add error bars so that's good. The problem is that you've now told excel to actually plot the minimum and maximum things as columns which is not what you want to do. When you're getting Excel to actually plot the graph, only select the mean values.

    The way error bars work in Excel is that it uses absolute error since this is the way you'd most commonly get error in scientific experiments. It's still possible to plot ranges but it just means we've got to do an extra step. Rather than telling Excel to explicitly plot the error bars between a minimum and maximum value, you've basically got to tell excel to plot error bars x units below your mean and y units above your mean.

    So say our mean is 10, the minimum is 7 and the maximum is 12, our negative error value needs to be 3 (10-7) and our positive error value needs to be 2 (12-10).

    If none of this making any sense then you're very welcome to PM me your data and I'll put it into Excel for you.
 
 
 
Reply
Submit reply
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.

Updated: March 7, 2016
  • See more of what you like on The Student Room

    You can personalise what you see on TSR. Tell us a little about yourself to get started.

  • Poll
    What's your favourite Christmas sweets?
    Useful resources
    Bizarre things students have spent their loans onThings you should budget for at uni

    Sponsored features:

    Making money from your own website

    Need some cash?

    How to make money running your own website.

    Bianca Miller, runner-up on The Apprentice

    Handle your digital footprint

    What would an employer find out about you on Google? Find out how to take control.

    Groups associated with this forum:

    View associated groups
  • See more of what you like on The Student Room

    You can personalise what you see on TSR. Tell us a little about yourself to get started.

  • 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

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