+ Reply to Thread
Results 1 to 3 of 3

Standard Deviation Error Bars for Individual Columns of a Bar Chart

  1. #1
    Registered User
    Join Date
    05-09-2014
    MS-Off Ver
    Excel 2013
    Posts
    8

    Standard Deviation Error Bars for Individual Columns of a Bar Chart

    Hi everyone!

    I am writing my thesis and I am having some troubles with adding standard deviation bars to my chart. I have a series of average times per task. So I had 2 independent groups test an interface twice. I took their average time for each task for one group and the other group. So I get a table like this:

    A B A B
    3D USER 3D USER 2D USER 2D USER
    Average Time Taken for Task 1 552.89 356.23 494.44 178.98
    Average Time Taken for Task 2 147.78 65.75 170.26 85.09
    Average Time Taken for Task 3 396.56 255.26 395.68 186.04
    Average Time Taken for Task 4 232.16 161.25 173.43 200.27

    This way I can create a 2D bar chart that looks like this:

    Chart.png

    As you can see the error bar is the same for all blue bars. Each blue bar is a different time for a totally different task. How do I add a an error bar, I can use my own custom value for standard deviation I have calculated earlier, but I cant get it to be separate for each bar.

    Hope I was clear enough.
    Last edited by Chris_SS; 07-08-2014 at 04:36 AM.

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

    Re: Standard Deviation Error Bars for Individual Columns of a Bar Chart

    Here is an explanation of how to use custom error bar values.
    http://peltiertech.com/WordPress/cus...-excel-charts/
    Cheers
    Andy
    www.andypope.info

  3. #3
    Registered User
    Join Date
    05-09-2014
    MS-Off Ver
    Excel 2013
    Posts
    8

    Re: Standard Deviation Error Bars for Individual Columns of a Bar Chart

    Sorry it took me so long to answer but, Thank you!

    I believe I had read this article before, but obviously not close enough. This solved my problem. Thanks again

+ 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. Replies: 4
    Last Post: 01-02-2014, 11:56 AM
  2. Shaded Standard Deviation or Error Bars
    By SillayKetha in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 03-20-2013, 01:24 AM
  3. Excel 2007 : Standard deviation error bars don't work
    By Marinegirl in forum Excel General
    Replies: 1
    Last Post: 08-17-2010, 03:26 PM
  4. error bars and standard deviation
    By Emily Stevens in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 05-17-2007, 11:08 AM
  5. Replies: 1
    Last Post: 01-21-2005, 01:06 PM

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