How to make a Dumbbell Dot Plot in Excel (100% dynamic) | Excel Off The Grid

★ Want to automate Excel? Check out our training academy ★
https://exceloffthegrid.com/academy

★ Get the example file ★
https://exceloffthegrid.com/dumbbell-...

★ About this video ★
Dumbbell dot plots are an excellent chart style for presenting comparative data. These chart styles quickly show the difference or progress between two data points.

Often, Excel tutorials for dumbbell dot plots create charts that require manual updating for new data. But using the right Excel techniques these charts can be fully dynamic.

So, in this video, we will create a dumbbell dot plot in Excel that updates automatically when we add new data.

0:00 Introduction
0:28 Data
1:11 Calculations
5:20 Named ranges
6:56 Create chart
8:34 Error bars
9:44 Format dots
10:48 Data labels
11:41 Category label
13:29 Delete the junk
13:49 Add new data
14:19 Conclusion

★ Download 30 most useful Excel VBA Macros ebook for FREE ★
https://exceloffthegrid.com/

★ Where to find Excel Off The Grid ★
Blog: https://exceloffthegrid.com
Twitter: Twitter: exceloffthegrid

#MsExcel