Forum Discussion
Jillian25
Apr 30, 2020Copper Contributor
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...
- 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.
Khizar_Hayat
May 01, 2020Brass Contributor
the advanced scatter plot use in excel 2016 or later it will be shown to you in given screen shot as well as in fileJillian25
- Jillian25May 01, 2020Copper Contributor
Hi Khizar_Hayat
I dont think that result in quite what I was looking for. More like this below but with my data. Thanks anyway