Create a Horizontal Box Plot

If you've go Excel 2016, you can now create box and whiskers chart (or box plots). It lets you create a vertical oriented box plot but not a horizontal (sideways or parallel) one. If you wanted to create a horizontal box plot, you'd have to take a couple of different steps (not many!) to make it out of a stacked bar chart with error bars (and keep your outliers visible). Take a look, it's not that hard!
🔔 SUBSCRIBE to my channel ➜ goo.gl/wN3c3p
🏫 Excel Training ➜ www.exceltraining101.com/p/tr...
📚 Excel Books & Tech Gear ➜ www.amazon.com/shop/dough
⚙️ Tools: Screencasting ➜ techsmith.z6rjha.net/5Qe53
⚙️ Tools: Microsoft Office ➜ microsoft.msafflnk.net/rKL0G
⚙️ Tools: TubeBuddy ➜ www.tubebuddy.com/et101
📝 This description may contain affiliate links and we'll receive a small commission if a purchased is made using the links (but at no additional cost to you). It'll support the channel and so more videos like this can be made. Thanks for your support!
🎁 If you find these videos useful and want to support my channel go to www.buymeacoffee.com/dough
#excel
#msexcel
#doughexcel
~-~~-~~~-~~-~
Please watch: "Convert Table in a PDF File to Excel"
• Convert Table in a PDF...
~-~~-~~~-~~-~

[@williamaxtell3613]

Thank you so much for this, such a useful tutorial for producing a vital chart by hand!

[@DougHExcel]

Hi William Axtell...you're welcome, glad you liked!

[@nliin]

You're a genuine life saver, thank you Doug so much love

[@DougHExcel]

You’re welcome ☺️ glad it helped! Have another that includes mean and median too. kzbin.info/www/bejne/m6fKaXSOZ9KnaZY

[@teresadanielleschmid]

Thanks so much for this super helpful instructional video!

[@DougHExcel]

Hi Teresa Schmidt...you're welcome, glad you liked!

[@gregsouthern160]

Avoided R Studio on my EMBA Stat final thanks to you! Well done!! feedback from others was very crucial and spot on.

[@DougHExcel]

Glad it helped!

[@toutpret]

Nice. Thank you. FYI, instead of doing all the work again, simply extend the chart data range. Excel automatically uses the existing formatting.

[@DougHExcel]

Hi David Murray, thanks for the comment!

[@thomasevans3060]

Thanks, this helped me so much!

[@DougHExcel]

Glad it helped!

[@KingSummerbody]

Saved my life thanks!

[@DougHExcel]

Glad it helped!

[@bferguson6103]

I am having a problem with this when trying for small number, less than 1. So instead of 421, 739, 860, 1007, 1306, When trying for 0.421, 0.739 etc., the chart doesn't work. Your directions need to specify the Minus Error bar for the lower whisker and the Plus Error bar for the upper whisker. Then, regardless of the magnitude of the numbers, the Box Plot works.

[@DougHExcel]

Hi Boyce Ferguson, thanks for adding to the thread!

[@josephshuffield6113]

Hi Doug--what if your min value is zero, and the next value is something far larger? I've created a box plot using your technique and it worked like a charm, but I think perhaps I need to deal with outliers differently.

[@DougHExcel]

Haven't tested it with zero min value...try a query to the mrxecel.com forum and see what the gurus say

[@josephdemarse5180]

Very helpful. However, the x and y-axis are switched in the 2020 version of excel. I thought the "switch row and column would be the solution but it isn't. Any suggestions?

[@DougHExcel]

Depends on how many series...try to start over and choose one series first to create the boxplot.

[@Rachel-ky3lr]

this is very helpful! what do I do if I have outliers?

[@DougHExcel]

this one covers outliers kzbin.info/www/bejne/b4Wuc4Z3ebajrrc

[@mingying9824]

@@DougHExcel not a horizontal one anymore

[@user-gq7xr7vo2x]

how would you add an outlier?

[@joshuaseideman5694]

I followed all of these steps, including selecting the 2-D stacked bar chart. When I go to design, Excel does not give me option to switch the row/column. I am using Excel from Microsoft 365 ProPlus. Any advise?

[@DougHExcel]

Hi Joshua Seideman, try a post on the mrexcel.com forum!

[@EpicFoXD333]

I have the same problem:(

[@pbv61]

Good video, but I have one snafu. The high point of my lower whisker and the low point of my upper whisker extend one point into the Q2 and Q3 shaded areas, instead of being on each outer edge as yours does. I have tried subtracting, adding, etc. I don't get it. Mine is set up just like yours, including a 0 axis value.

[@pbv61]

Disregard. I figured it out. If anyone else does this. You have to enter error bars on Q1 to Q2 series (blanked out one.). Also for lower, you have to click on NEG only. On upper whisker, use POS only

[@NinjaPenguins9000]

Any tips on how to go about if I want to see all my data points as dots as well?

[@DougHExcel]

probably as a separate chart probably scatter kzbin.infosearch?query=scatter+chart

[@NinjaPenguins9000]

@@DougHExcel Wow, thanks for the quick reply! I'll try it out!

[@Rbonnet31]

I have values on a range from -300 to +300, and it seems your method does not work for data that can be negative... Any tip ?

[@DougHExcel]

Hi Raphael Bonnet, sorry 🙁....but try a post on the mrexcel.com forum!

[@danielbalan4392]

how do I make a “dot” to represent the mean on the whisker plot?

[@DougHExcel]

You'd need another row that has the mean value and add it in as a scatter chart. Maybe a vid for the future coming.

[@danielbalan4392]

@@DougHExcel thanks! But do I add a new row consisting of the mean below the top whisker?

[@garrymendez1654]

Can this be done with Google Sheets?

[@DougHExcel]

Don't know...I haven't tried it yet 🤔

[@hannahliew9136]

why is my whisker is a little bit inside the box? 😭

[@DougHExcel]

maybe the size of the chart or plot area? make the chart a bit larger to see

[@bjarbj944]

you went way too fast on the error bars I watched it multiple times and am still having trouble figuring out how you added the second whisker

[@DougHExcel]

Bjarb J, that is very interesting...thanks for letting me know.

[@gregsouthern160]

Slow the speed down! He sounded drunk but that did the trick.. ;)