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

preview_player
Показать описание
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

IMPROVE YOUR DATA VISUALIZATION & STORYTELLING SKILLS

INTRODUCING OUR NEW BOOK - AVAILABLE TO PREORDER
📚 STORYTELLING WITH DATA: BEFORE & AFTER

WORKSHOPS and 8-WEEK COURSE - Use YOUTUBE10 for 10% off!

ADDITIONAL RESOURCES

STAY CONNECTED
  1. storytelling with data
  2. #ExcelTutorial
  3. #datavisualization
  4. #dotplots
  5. #Microsoft Excel
  6. #Excel
Рекомендации по теме
How to create 0:11:54

How to create a spreadsheet in excel in 5 minutes | excel for beginners

Excel for Beginners 0:54:55

Excel for Beginners - The Complete Course

How to Change 0:05:42

How to Change a Theme and Make it the Default in Excel

Excel for fresher 0:00:37

Excel for fresher Excel tutoring Excel for beginners Job interview questions

How To Create 0:00:29

How To Create An Excel Table

How to Merge 0:00:11

How to Merge 2 Cells in Excel! #excel

COUNTIF function in 0:00:14

COUNTIF function in Excel! #excel

How to Make 0:03:16

How to Make a Pie Chart in Excel

👌MS Excel Home 0:00:03

👌MS Excel Home Tab Functions #shorts #excel

Excel tip advanced 0:00:12

Excel tip advanced filter unique values

Use Sum Formula 0:00:06

Use Sum Formula In Excel | Excel Sum Formula In Hindi

How to Make 0:03:57

How to Make a Totaling Column Formula in Excel : Using Microsoft Excel

How To Merge 0:00:14

How To Merge Cells in Excel! #excel #exceltutorial #exceltips

Excel Formulas and 0:12:29

Excel Formulas and Functions Tutorial

How to Create 0:03:42

How to Create a Table in Excel (Spreadsheet Basics)

How to Make 0:00:41

How to Make a Graph in Excel

Excel Trick: How 0:00:19

Excel Trick: How to quickly insert heading after 5 rows in excel.

How to use 0:00:14

How to use VLOOKUP in Excel! #excel

Serial Number in 0:00:13

Serial Number in excel shortcut || Automatic serial Number in Excel

Excel Tip: Sort 0:00:14

Excel Tip: Sort names alphabetically

How to Make 0:06:48

How to Make Tarpapel using Microsoft Excel? | Tagalog Tutorial

How to Insert 0:00:22

How to Insert an Excel file into MS Word?

Excel tip to 0:00:27

Excel tip to filter with images staying the right size #exceltips #excel #exceltricks

How to Make 0:16:10

How to Make a Risk Assessment Matrix in Excel

Комментарии
Автор

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

hectore.zarraga
Автор

Excellent and very helpful presentation. Cheers!

donniemcgee
Автор

Really Cool! Love the error bar hack! 👍

SpotlightImpact
Автор

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

swatisinha
Автор

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.

VeejayDiesel
Автор

HOw did you add th names of the categories in the Y axis? That part is missing

olgachanturia
Автор

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

triciatcy
welcome to shbcf.ru