+ Reply to Thread
Results 1 to 3 of 3

Individual Standard Deviation Values for Each Column

  1. #1
    Registered User
    Join Date
    04-11-2009
    Location
    Toronto
    MS-Off Ver
    Office 2007 Ultimate
    Posts
    3

    Individual Standard Deviation Values for Each Column

    I have data points that are the averages of several individual pieces of data. I want to display the mean value with positive and negative standard deviation that describe the numbers that make up that mean. There are a total of five of these mean values that I need to show.

    I've attached both an Excel file with the data, and a .jpg file that I generated with SigmaPlot showing how it should look. Each error bar is individual to the bar that it's associated with (values in the Excel file).

    Does anyone know how to enter individual standard deviation values for each data point in Excel 2007? I could just use SigmaPlot to do all of the graphs, but that program is much slower to use, and the graphs are very ugly; since I need many of these graphs for a presentation, it's important that they look uniform and nice.

    Thanks so much in advance.
    Attached Images Attached Images
    Attached Files Attached Files
    Last edited by Maurice.; 04-14-2009 at 11:47 PM.

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

    Re: Individual Standard Deviation Values for Each Column

    Select the series then via Chart Tools > Layout > Analysis > Error bars > More Error bars options.

    On the Vertical Bars tab use the Specify Value button to select the range
    =Sheet1!$B$2:$B$6

    for both Positive and Negative values.
    Attached Files Attached Files
    Cheers
    Andy
    www.andypope.info

  3. #3
    Registered User
    Join Date
    04-11-2009
    Location
    Toronto
    MS-Off Ver
    Office 2007 Ultimate
    Posts
    3

    Re: Individual Standard Deviation Values for Each Column

    Hey Andy,

    Thanks so much for your help, that's perfect.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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