Jitter plot in Excel | 100% dynamic | Excel Off The Grid

[@robbe58]

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.

[@ExcelOffTheGrid]

Thank you. That is very kind of you to say 😁. I’m just trying to help us all automate our work through good practices.

[@tibibara]

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!

[@ExcelOffTheGrid]

That is very true - good point.

[@IvanCortinas_ES]

Great great video Mark. Excellent explanation. Thank you for sharing!

[@ExcelOffTheGrid]

Thanks Ivan. Glad it was helpful. 😁

[@FernandodeCarvalhoNavarro]

Phantastik!

[@ExcelOffTheGrid]

You're welcome.

[@spen2431]

Wizardry ! Amazing work. Thanks for sharing 👍💥

[@ExcelOffTheGrid]

You're welcome 👍

[@rus1ickoff]

I couldn’t agree more. Excellent and creative as always!

[@ExcelOffTheGrid]

Thank you. The process/framework is great for lots of different charts.

[@launchexcel]

Great video Mark. It's packed with info!

[@ExcelOffTheGrid]

Thanks Victor 😁

[@tahirhanif9669]

Excellent and straight to the point, Thank you

[@ExcelOffTheGrid]

Thank you. I'm glad it was easy to follow.

[@francescox79]

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

[@kebincui]

Excellent and creative as always. Thanks Mark👍❤🌹

[@ExcelOffTheGrid]

Thanks Kebin 😁

[@duncanwil]

You mentioned your use of a data table twice in this video, Mark but I didn’t see how you did that.

[@ExcelOffTheGrid]

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.

[@duncanwil]

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