Create Horizontal Box Plot with Mean and Median

Doug H
Doug H
13.2 هزار بار بازدید - 3 سال پیش - Box and whisker charts are
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  ➜ https://goo.gl/wN3c3p

🏫 Excel Training ➜ https://www.exceltraining101.com/p/tr...

📚 Excel Books & Tech Gear  ➜ https://www.amazon.com/shop/dough

⚙️ Tools: Screencasting ➜ https://techsmith.z6rjha.net/5Qe53

⚙️ Tools: Microsoft Office ➜  https://microsoft.msafflnk.net/rKL0G

⚙️ Tools: TubeBuddy ➜  https://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 https://www.buymeacoffee.com/dough

#excel
#msexcel
#doughexcel

~-~~-~~~-~~-~
Please watch: "Convert Table in a PDF File to Excel"
Convert Table in a PDF File to Excel
~-~~-~~~-~~-~
3 سال پیش در تاریخ 1400/08/16 منتشر شده است.
13,263 بـار بازدید شده
... بیشتر