+ Reply to Thread
Results 1 to 3 of 3

Excel 2007 : Error Bars-how does one add different standard dev bars?

  1. #1
    Registered User
    Join Date
    09-10-2010
    Location
    Connecticut, USA
    MS-Off Ver
    Excel 2007
    Posts
    11

    Error Bars-how does one add different standard dev bars?

    I am working with two graphs (QI.xls)

    my main question is, how does one add different standard dev bars on 2D bar graphs?

    looking at my excel sheet, the tab (Grapth_Theme_Year) is based on the tab (datatable).
    If you noticed in datatable tab, 2008 and 2009 has different SD. How do I add that in Excel 2007? I found the add error bar tab in the menu, but it seems that I can only add one constant value for both bars (so if it's 2, it would be 2008 +- 2 and 2009 +- 2.. instead of it should be 2008 +-1 and 2009 +-2).

    Secondly, I would like to add additional information for the datatable under the Grapth_Theme_Year's graph. So i would like the table to show the SD, low and high values that is listed under the datatable tab. how does one do this?

    The other graph, I would like to just add the error bar to the last (red) bar.

    I basically want my graphs to look like the one in the sample.xls file. This graph was copied from a powerpoint slide over to excel. Sadly, it was pasted into the powerpoint as a picture, so I can't figure out how they did it. So as you notice in the sample.xls file, the bar graph is graphing the value, there is a different stand dev error bar for each bar graph and the datatable has extra elements that was not in the graph (best in class, low, mean). That is what basically what I want for my data. How does one do this in Excel 2007?
    Attached Files Attached Files
    Last edited by pennywaltz; 10-14-2010 at 03:10 PM. Reason: Added sample graph

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

    re: Error Bars-how does one add different standard dev bars?

    The extra items will appear in the data table if you add them to the chart.
    If you set the fill to none for the additional series and the Overlap to 100 then you will not see them in the chart.

    In the example I have set the transparency so you can see where the extra series are.

    On the Error bars dialog is the option to use custom values. Just select the cells you want to use for each data point.
    Attached Files Attached Files
    Cheers
    Andy
    www.andypope.info

  3. #3
    Registered User
    Join Date
    03-28-2012
    Location
    London
    MS-Off Ver
    Excel 2007
    Posts
    1

    Re: Error Bars-how does one add different standard dev bars?

    Hey I tried doing that but it didnt work

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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