💪🏻 Create a Connected Dot/Dumbbell Chart in Excel

Create a Dumbbell/Connected Dot Plot Chart in Excel!

A dumbbell chart, also known as a DNA chart or connected dot plot, is a type of chart in Excel used to compare two or more data points along the same axis.

This chart is particularly useful for visualizing changes or differences between points, such as before and after values, different time periods, or comparative metrics.

In a dumbbell chart, each data point is represented by a series of dots connected by a line, resembling a dumbbell. This makes it easy to see the magnitude and direction of changes between the points.

In this lesson we are going to create from scratch a multi-point dumbbell chart based on data related to the Euro 2024 football tournament. ⚽️🏆🥅

Download Workbook ⬇️

#msexcel

************************************************

🔗LINKS to related videos

🥩The SILENCE of the LAMBDA -- Create Your Own Excel Functions

💬TEXTBEFORE and TEXTAFTER -- New Excel Functions

🪓SPLIT TEXT using Multiple Delimiters

************************************************

🤝Let's CONNECT on social:

[XMotionVideos]

Thanks. You’ve got a beautiful voice 😂😂

[craigbeuthin]

Fantastic, it is going to be so useful - Thank you

[RameshS-vf]

Amazing tutorial first of its kind. Very useful application.

[zeeshandhirani]

Pls help. What formula do I use in excel for the following: cost price + 160% (markup).