Jitter plot in Excel | 100% dynamic | Excel Off The Grid
Вставка
- Опубліковано 3 лип 2024
- ★ Want to automate Excel? Check out our training academy ★
exceloffthegrid.com/academy
★ Get the example file ★
exceloffthegrid.com/jitter-pl...
★ About this video ★
A jitter plot is a really powerful data visualization showing the spread of individual data points.
This video looks at how to create a dynamic jitter plot in Excel.
0:00 Introduction
0:09 Data & scenario
1:13 Label calculation
3:26 Value calculations
8:00 Data validation list
10:24 Create chart
12:19 Chart formatting
14:48 Adjusting axis scale
16:56 Testing
17:51 Conclusion
★ Download 30 most useful Excel VBA Macros ebook for FREE ★
exceloffthegrid.com/
★ Where to find Excel Off The Grid ★
Blog: exceloffthegrid.com
Twitter: / exceloffthegrid
#MsExcel
Hi Mark,
Very well structured and clearly explained. (as always)👌👋
Useful in many ways (also to prepare other data)
I am a fan of your videos and already have a membership to one of your courses.
Thank you for the hard work and commitment to help us learn to use Excel in a professional way.
Thank you. That is very kind of you to say 😁.
I’m just trying to help us all automate our work through good practices.
Great great video Mark. Excellent explanation. Thank you for sharing!
Thanks Ivan. Glad it was helpful. 😁
Wizardry ! Amazing work. Thanks for sharing 👍💥
You're welcome 👍
Hi Mark, brilliant solutions, I'm impressed! Thanks a lot! 😇
Just one important thing to consider -> calculate event in case of auto calculate settings will kill our UNDO-CACHE every time when the sheet is calculated!
That is very true - good point.
Great video Mark. It's packed with info!
Thanks Victor 😁
I couldn’t agree more. Excellent and creative as always!
Thank you. The process/framework is great for lots of different charts.
Excellent and straight to the point, Thank you
Thank you. I'm glad it was easy to follow.
Excellent and creative as always. Thanks Mark👍❤🌹
Thanks Kebin 😁
Amazing 👏 🎉
At the moment im struggling with one task, maybe you can support me how to do.
Task:
Which two items are the most frequently used item. Consider the transaction code.
Table 1:
Column A: transaction
Column B: item
Column C: quantity
Table 2:
Column A: all possible combination of the items
Column B: (result) how often the combination has been used.
It would help me a lot, thanks in advance
You mentioned your use of a data table twice in this video, Mark but I didn’t see how you did that.
I put everything in a Table as it has automatic expansion for formula references.
Select a cell in the data, then press Ctrl + T, or click Insert > Table.
I thought that was the case ... so it's not a data table at all, which, as you know, is a special case in Excel. By the way, I have been a user of jitter plots for a few years now and I would respectfully suggest that the range you have set for the width of the jitters is a bit wide and I would probably use no more than half of the range you have set. Otherwise, they are a great addition to our world of visualisation,@@ExcelOffTheGrid