Create Horizontal Box Plot with Mean and Median

Рет қаралды 13,026

2 жыл бұрын

Box and whisker charts are something that is easy to create in Excel if you’ve got version 2016 or higher. There’s the option to create a vertical box plot but unfortunately there’s no option to create a horizontal box and whiskers chart. It’s actually fairly easy to create a sideways box plot by modifying a stacked column chart and adding a scatter chart for the mean (average) value.
🔔 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...
~-~~-~~~-~~-~

Пікірлер: 12

@wayneedmondson1065 2 жыл бұрын

Hi Doug. Very creative solution! Thanks for sharing. Thumbs up!!

@DougHExcel 2 жыл бұрын

Thanks again Wayne!

@Thunderin11 Жыл бұрын

Great tutorial! Guess what? This is also a valid tutorial for Excel 2010 wherein the statistical chart isn't even an option! I watched an Excel 2010 dedicated tutorial in KZbin which didn't include adding the Mean and had troubles working it out on my own, your tutorial did exactly that and saved me a lot of hassle to keep experimenting independently.

@DougHExcel Жыл бұрын

Glad it was helpful!