Results 1 to 4 of 4

How do I plot mean and sd on the same graph?

This is a discussion on How do I plot mean and sd on the same graph? within the Excel Questions forums, part of the Question Forums category; Hello, i would like to plot mean and standard deviation like this: http://www.nzfooddaily.co.nz/Portals...ience-blog.jpg I already have a dataset of mean ...

  1. #1
    New Member
    Join Date
    May 2009
    Posts
    2

    Default How do I plot mean and sd on the same graph?

    Hello,

    i would like to plot mean and standard deviation like this:

    http://www.nzfooddaily.co.nz/Portals...ience-blog.jpg

    I already have a dataset of mean and SDs, but i really don't have a clue on how to show them on a graph.

    Thanks for any hint

    Cheers!

  2. #2
    Board Regular btadams's Avatar
    Join Date
    Jan 2003
    Location
    Richmond, Va
    Posts
    1,874

    Default Re: How do I plot mean and sd on the same graph?

    Just make a bar chart and add error bars to it (right-mouse click on the series in the chart and choose Format Data Series and then click the Y Error Bars tab).

    Alternatively, the data could better be displayed using boxplots. Do a google search on Excel and Boxplots and you should find instructions.
    “The early bird gets the worm, but the second mouse gets the cheese.”

    Put Yourself on the Excel Map:
    http://www.mapservices.org/myguestmap/map/MrExcel

    Instructions for Map:
    http://www.mrexcel.com/map.html

  3. #3
    New Member
    Join Date
    May 2009
    Posts
    2

    Default Re: How do I plot mean and sd on the same graph?

    Thanks for your answer! Error bars are what I was looking for.
    (Boxplots are messing my graphs too much, but thx anyway)

    Still have a problem: since I have a table with standard deviations, and would like to add them as error bars, I need to select a bidirectional error bar and insert the error amount as "custom" -> "positive and negative" from my dataset.
    Is there a better way than simply split my SD and add them as positive and negative error?

    (i really have lot of data and many series to plot, it ll therefore simplify my life)

    Thanks again!

  4. #4
    Board Regular btadams's Avatar
    Join Date
    Jan 2003
    Location
    Richmond, Va
    Posts
    1,874

    Default Re: How do I plot mean and sd on the same graph?

    Not sure if I understand the problem correctly, but if you have your sd's in say C2:C100, then in order to add ± 1 s error bars, you would enter that same range in the two custom error bars boxes
    “The early bird gets the worm, but the second mouse gets the cheese.”

    Put Yourself on the Excel Map:
    http://www.mapservices.org/myguestmap/map/MrExcel

    Instructions for Map:
    http://www.mrexcel.com/map.html

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


DMCA.com