View Single Post
  #1   Report Post  
Qcom12 Qcom12 is offline
Junior Member
 
Posts: 0
Default Scatter plot with multiple Y-values and same X value.

Hi all, I began working in a clinical research lab today, and the experimenters have put me straight to work. I am trying to create a marked scatter plot (with no line, this is their personal request) consisting of data obtained from 3 different test groups, with the clinical value plotted on the Y-axis and the month (multiple month long experiment) plotted on the X-axis. Thus, I have say, 25 points all under a single given X value, e.g. month 1. I was wondering if there's a way to "spread out" the values so that you can see each individual point, thereby stretching the points out along the X-axis so they aren't clustered so close together. Below is a screen shot of what the chart looks like, my apologies for not being able to articulate what I want well, to say I'm an excel novice would be an understatement.

http://imageshack.us/photo/my-images...0618at353.png/