In this video, I show how you can create a horizontal and vertical dumbbell plot in r and the set data label position, add colours, titles, subtitles and callout text.
#rstat #dataanalyst #rstudio
📁 Dataset for horizontal dumbbell plot
https://data.world/deanchereden/football/workspace/file?filename=EPL+2022+2023+Arsenal+%26+Man+City.csv
📁 Rscript for horizontal dumbbell plot
https://data.world/deanchereden/football/workspace/file?filename=R+Dumbbell+Plot+-+EPL+Team+Position+2022+-+2023.R
📁 Dataset for vertical dumbbell plot
https://data.world/deanchereden/football/workspace/file?filename=MU+MC+Chel+Liv+EPL+Results+1992-2023.csv
📁 Rscript for vertical dumbbell plot
https://data.world/deanchereden/football/workspace/file?filename=R+Dumbbell+Plot+-+EPL+Team+Finish+1992+-+2023.R
▶️ How to get more football data using worldfootballr
https://youtu.be/6ZdgEQbn7vo
🔖c h a p t e r s 🔖
00:00 - Intro
00:27 - Horizontal dumbbell plot
00:47 - Install & load in packages
01:12 - Load in the dataset
01:49 - Create a simple dumbbell plot
04:25 - Change the dumbbell colours
05:02 - Clean up the plot using a theme
06:32 - Change x & y titles and scale the y-axis
07:36 - Add data labels
09:37 - Add a column to the table to show the max
12:41 - Create a plot with correct data labels
14:49 - Match line colour to data labels
16:02 - Add title & subtitle wording
21:08 - Vertical dumbbell plot
21:37 - Load in packages & dataset
22:20 - Filter data
22:40 - Create the dumbbell plot
23:33 - Reverse the x-axis
24:30 - Move the y-axis to the right side
24:57 - Add max to the data table
26:17 - Plot with data label blank & n/a fix
28:06 - Flip plot to make vertical
28:25 - Rotate the y-axis to stop overlapping
29:13 - Flip the y-axis
29:36 - Title & subtitle with extra wording
33:36 - Add callout text with lines
My RStudio Appearance Setup
RStudio theme: Modern
Zoom: 100%
Editor font: Lucida Console
Text rendering: (Default)
Editor font-size: 16
Editor theme: Tomorrow Night 80s
To learn how to change your appearance in RStudio here: https://youtu.be/GsiTBOyd7ss?t=161
Contact and Socials
💌 My email - dean@deanchereden.com
🌍 My website - https://www.deanchereden.com
🐦 Twitter - https://twitter.com/deanchereden
Music
🎵 Vhsceral - Gimetime https://chll.to/dd82e17f
🎶 Listen to Chillhop Music - https://youtu.be/kpO-nyGEBJ4