How to Make A Horizontal Jitter Plot in Excel🧑‍💻 [EXCEL TIPS! 📊]

[@SpotlightImpact]

Grab data design downloads from our shop on Gumroad: spotlightimapct.gumroad.com

[@TicTacs4everyone]

You helped me sooo much. It's the middle of the night and I was desperat. Thank you so much!

[@SpotlightImpact]

You’re so welcome! I’m Glad to be of service! 🤙🏻

[@spilledgraphics]

🔥🔥🔥🔥🔥🤯🔥🔥🔥🔥🔥 this is fantastic! Kudos Nick! 👌

[@womensgames952]

thank you for shearing this treasure on linkedin

[@SpotlightImpact]

Thanks so much!!

[@SpotlightImpact]

Thank you! 🙏🏻

[@rhabdomere]

This is so helpful and thank you so much!

[@SpotlightImpact]

Yay! I’m glad it was useful!

[@benediktk.8228]

Is there a way to add the standard deviation to the average-dot ?🤔

[@SpotlightImpact]

Definitely! I made a video that'll premiere in about 10 minutes here kzbin.info/www/bejne/moeyXp6Kob-rldE You can add that SD, by working with the horizontal error bars on the average dot in the jitter plot. Then customize the length of the error bar by pointing to the cell with your calculated SD.

[@benediktk.8228]

@@SpotlightImpact wow, thank you so much for the fast answer!

[@SpotlightImpact]

🙌🏼

[@Sthriven]

is there any way to to make the Y Axis to be a named category instead of numerical value?

[@SpotlightImpact]

With an XY scatter chart there isn’t a way for the y axis to be text by default but you can “hack” the y axis using other chart elements. You could create the y labels like we do here kzbin.info/www/bejne/mpzKmmOPbKahkNEsi=7iCl2t_u2vcMqbxB

[@SpotlightImpact]

Another option would be to create a combo bar chart + XY scatter whet the bar chart has your y labels and the XY scatter is your jittered dot markers - using the trick we used here kzbin.info/www/bejne/p6aVeHWiZZl6rKM