Make it in Excel! | Two different types of dot plots

Dot Plots aren't standard chart types in Excel so we need to be a little creative when making them. This video goes step by step through making two versions, the Cleveland and Connected Dot Plots.
JUMP TO THE SECTION THAT INTERESTS YOU
00:00 Intro
00:24 What is a dot plot?
02:12 How to make a cleveland dot plot?
06:22 How to make a connected dot plot?
12:45 BONUS - How to make a connected dot plot - version 2
14:45 Making category labels dynamic
16:45 Recap and outro
BONUS RESOURCES
● Create a dot plot - step by step in this written article: www.storytellingwithdata.com/...
● What is a dot plot? Find out along with many other graph types in our chart guide: www.storytellingwithdata.com/...
● SWD chart guide: www.storytellingwithdata.com/...
● SWD challenge - let’s plot with a dot:: www.storytellingwithdata.com/...
HONE YOUR DATA VISUALIZATION & DATA STORYTELLING SKILLS
📊 Practice in the #SWDcommunity: community.storytellingwithdat...
🎧 Listen to #SWDpodcast: www.storytellingwithdata.com/...
📚 Read the #SWDbooks: www.storytellingwithdata.com/...
🖥 Follow the #SWDblog: www.storytellingwithdata.com/...
🍎 Attend a #SWDworkshop: www.storytellingwithdata.com/...
STAY CONNECTED
👉 LinkedIn: / storytelling-with-data...
👉 Twitter: / storywithdata
💡 Don’t forget to subscribe for new videos! ruclips.net/user/storytellin...

[@donniemcgee7523]

Excellent and very helpful presentation. Cheers!

[@storytellingwithdata]

You're welcome! Thanks for watching :-)

[@petradabic4671]

Amazing inputs SImon! Thank you.

[@storytellingwithdata]

Thank you, Petra! So glad you found it useful! :)

[@SpotlightImpact]

Really Cool! Love the error bar hack! 👍

[@storytellingwithdata]

Thanks! Yes, those error bars can come in handy!

[@hectore.zarraga7605]

Really nice. Never seen a Cleveland dot plot chart, super keen to try it at work! thanks for content :)

[@rajdeepmukherjee2021]

That error bar shortcut!!! Great1

[@swatisinha3230]

I prefer the error bars, simple & fewer steps to do the same thing :)

[@storytellingwithdata]

Yes, they can be pretty useful. Thanks for watching :-)

[@luthfisaifularif8064]

Amazing

[@broonzy2006]

Love these! Each time I add the max values they disappear. I had them once as dots but when changing to bar chart they disappear. Very frustrating. Probably because I'm on a Mac 🤷🏻‍♂. 1 hour later.... I got it to work nicely. It certainly helped to add all data series in bar chart format first before moving things around with Y and X axis - that was causing something weird to happen 🔥 Thanks! it's a nice lookin' chart.

[@triciatcy]

How do we change the Y Axis to show the category names?

[@storytellingwithdata]

There are a couple of ways to do this. You could add text boxes to the chart and type the category names. This works well for ad-hoc charts that you are making quickly. You could also build this functionality into the chart by creating a 'dummy' variable, as mentioned at 14:58.

[@DavidWakelyn]

Skipping over how to insert the text boxes for all the data categories makes this video functionally useless.

[@superfreiheit1]

Where is the car dataset?

[@storytellingwithdata]

Thanks for watching, Joe. The dataset was just a simple one made up to demonstrate the dot plot build. Any data will work with the same structure.

[@kalib4530]

This was really helpful, thank you! This video has a neat trick for labeling your Y lines: ruclips.net/video/eecYqcwK_X0/видео.html

[@storytellingwithdata]

Thanks for sharing. That's clever-use dummy data to build the labels into the graph. Love it!