Create Horizontal Box Plot with Mean and Median
Vložit
- čas přidán 22. 08. 2024
- 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.exceltrain...
📚 Excel Books & Tech Gear ➜ www.amazon.com...
⚙️ Tools: Screencasting ➜ techsmith.z6rj...
⚙️ Tools: Microsoft Office ➜ microsoft.msaf...
⚙️ Tools: TubeBuddy ➜ www.tubebuddy....
📝 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.buymeacoff...
#excel
#msexcel
#doughexcel
~-~~-~~~-~~-~
Please watch: "Convert Table in a PDF File to Excel"
• Convert Table in a PDF...
~-~~-~~~-~~-~
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 CZcams 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.
Glad it was helpful!
Hi Doug. Very creative solution! Thanks for sharing. Thumbs up!!
Thanks again Wayne!
THANK U SOOO MUCH!!!
Hi vitor damasceno, you're welcome!
Useful video.
Glad you think so! Thanks for the comment!
@@DougHExcel No problem. Check your email messages. Thanks.
How would you plot the outliers?
how to show the formula and the result at the same time
Try this Show Formulas in Cells - Excel #Shorts
czcams.com/users/shortsiuX6q1lU6Ak?feature=share