ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Charts and Charting in Excel (https://www.excelbanter.com/charts-charting-excel/)
-   -   Scatter plot with multiple Y-values and same X value. (https://www.excelbanter.com/charts-charting-excel/446367-scatter-plot-multiple-y-values-same-x-value.html)

Qcom12

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/


All times are GMT +1. The time now is 08:15 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com