💪🏻 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 ⬇️
docs.google.co...
#msexcel
************************************************
🔗LINKS to related videos
🥩The SILENCE of the LAMBDA -- Create Your Own Excel Functions
• The Silence of the LAM...
💬TEXTBEFORE and TEXTAFTER -- New Excel Functions
• ⭐️ NEW Excel Functions...
🪓SPLIT TEXT using Multiple Delimiters
• 🖖 Split Text Using Mul...
************************************************
🤝Let's CONNECT on social:
➡️TikTok: / cellmates_
➡️Instagram: / cellmatestr. .
➡️LinkedIn: / deborahas. .
➡️Twitter: / cellmates_
➡️Facebook: / cellmates

[@kevinbolt999]

Great explanation

[@hazemali382]

Amazing Video ♥

[@user-fr9of7gn5k]

Amazing tutorial first of its kind. Very useful application.

[@cellmatestraining]

Glad you liked it! :)

[@XMotionVideos]

Thanks. You’ve got a beautiful voice 😂😂

[@cellmatestraining]

Oh thank you! 🤩

[@SpotlightImpact]

Excellent explanation!

[@cellmatestraining]

@@SpotlightImpact thank you!

[@craigbeuthin4299]

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

[@cellmatestraining]

Glad it was helpful!

[@zeeshandhirani307]

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

[@DebAshby]

=SUM(Cost Price*160%)+Cost Price. Use cell references instead of hard coding the values into the formulas

[@zeeshandhirani307]

@@DebAshby just to understand if I just do cost + mark up wouldn’t that be the same. I wish there was tutorial or like a sheet sheet that explains this

[@cellmatestraining]

@@zeeshandhirani307 that will just give you the markup amount. If you want the cost with the markup added you need to use my method.

[@zeeshandhirani307]

@@cellmatestraining got it. Will try it out. Thank you so much