+ Reply to Thread
Results 1 to 3 of 3

How to create a box and whisker plot with SD and SEM

  1. #1
    Registered User
    Join Date
    03-11-2019
    Location
    Sweden
    MS-Off Ver
    Office 365
    Posts
    12

    How to create a box and whisker plot with SD and SEM

    Hi,
    I would like to create a box and whisker plot in Excel that displays the mean, the standard error of the mean as the boxes and the standard deviation as the whiskers. When I try to do it myself I can only manage to create a box and whisker plot with the interquartile range as the boxes and the minimum/maximum values as the whiskers. I've tried to search for solutions for a couple of hours, but to no avail. It would mean a lot if anyone here could help me out!

    Here's a picture of what I want it to look like: Box-Whisker-plot-Mean-value-standard-deviation-and-standard-error-of-the-results-in-the_Q320.jpg

    I'll also post my spreadsheet with the "faulty" box and whisker plot.

    Thanks in advance!
    Lymoz
    Attached Files Attached Files

  2. #2
    Forum Guru
    Join Date
    04-13-2005
    Location
    North America
    MS-Off Ver
    2002/XP and 2007
    Posts
    15,802

    Re: How to create a box and whisker plot with SD and SEM

    Upon opening your file, I see that you are using the new specialty box and whisker chart type. In my experience (from the outside looking in so to speak) most of these new specialty chart types are very limited in their options. If you cannot readily find options for using something other than quartiles for the box and whisker points, those options may not be available as part of the new specialty charts.

    However, most of these specialty charts were easily created in older versions of Excel using various basic chart types (and combinations). For your example, a box and whisker chart can easily be created as a stacked column chart. The advantage of the "old fashioned" way of doing this is you have the flexibility of defining your values in any way you want. Compute the necessary values (mean, standard error, standard deviation, and various ancillary data as needed) in the spreadsheet, then build the chart as a stacked column chart. See tutorial here: https://peltiertech.com/excel-box-an...ams-box-plots/
    Quote Originally Posted by shg
    Mathematics is the native language of the natural world. Just trying to become literate.

  3. #3
    Registered User
    Join Date
    03-11-2019
    Location
    Sweden
    MS-Off Ver
    Office 365
    Posts
    12

    Re: How to create a box and whisker plot with SD and SEM

    Thanks!! That did it!

+ 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. Box and Whisker Plot - highlight a point
    By rcal43 in forum Excel Charting & Pivots
    Replies: 5
    Last Post: 12-16-2019, 05:01 PM
  2. box and whisker plot x axis
    By DominikaM in forum Excel Charting & Pivots
    Replies: 3
    Last Post: 02-25-2017, 08:52 PM
  3. Box and Whisker Plot
    By marshymell0 in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 03-08-2013, 10:32 PM
  4. Excel 2007 : Error in making a box-and-whisker plot
    By flyingcurry in forum Excel General
    Replies: 3
    Last Post: 12-01-2011, 08:49 AM
  5. box whisker plot
    By flyingmeatball in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 05-09-2007, 11:11 AM
  6. [SOLVED] how do I create a box-plot (or whisker plot ) graph?
    By raal in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 08-08-2005, 04:05 PM
  7. How do I draw a Box and Whisker Plot in Excel?
    By angela268 in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 04-24-2005, 04: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