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.
The categories were manually added to the graph via a text box. Select the chart, then on the Insert tab, choose the Text Box option. You can then type the labels and adjust the spacing as needed to align with the gridlines. This is a brute-force approach that works well for ad-hoc charts.
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.
Really nice. Never seen a Cleveland dot plot chart, super keen to try it at work! thanks for content :)
Excellent and very helpful presentation. Cheers!
You're welcome! Thanks for watching :-)
Amazing inputs SImon! Thank you.
Thank you, Petra! So glad you found it useful! :)
Really Cool! Love the error bar hack! 👍
Thanks! Yes, those error bars can come in handy!
That error bar shortcut!!! Great1
I prefer the error bars, simple & fewer steps to do the same thing :)
Yes, they can be pretty useful. Thanks for watching :-)
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.
HOw did you add th names of the categories in the Y axis? That part is missing
The categories were manually added to the graph via a text box. Select the chart, then on the Insert tab, choose the Text Box option. You can then type the labels and adjust the spacing as needed to align with the gridlines. This is a brute-force approach that works well for ad-hoc charts.
Can it be done in Google Sheets?
Yes, you should be able to. Similar to Excel, Google Sheets doesn't have a built-in dot plot option, but it can be brute-forced with a scatterplot.
How do we change the Y Axis to show the category names?
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.
Skipping over how to insert the text boxes for all the data categories makes this video functionally useless.
Where is the car dataset?
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.
Amazing
This was really helpful, thank you! This video has a neat trick for labeling your Y lines: th-cam.com/video/eecYqcwK_X0/w-d-xo.html
Thanks for sharing. That's clever-use dummy data to build the labels into the graph. Love it!