Forum Discussion

Jillian25's avatar
Jillian25
Copper Contributor
Apr 30, 2020

Jitter VERTICALLY

Hi Excel community   I want to jitter a scatterplot.  I have found many posts about this but none give me the steps to create the visual I am trying to achieve.  I'm looking to achieve a vertical s...
  • Riny_van_Eekelen's avatar
    May 01, 2020

    Jillian25 What your picture shows can be achieved with a number of regular line charts that only shows the data point markers. The line format is thus "No line" and you format all line markers to your liking with respect to size and colour. 

    In the attached example, I used your 12 values and plotted 8 individual series where each data point is one below its predecessor, but never less then zero.

Resources