Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Junior Member
 
Posts: 0
Default Scatter plot with multiple Y-values and same X value.

I just started working for a team working on a clinical experiment and have been charged with the responsibility of compiling the data into scatter plot graphs in Excel. There are multiple groups, with clinical findings plotted on the Y axis and month on the X axis (multi-month long study). The team leaders want all the data points plotted on a scatter chart, so they can quickly glance at the data and determine trends. I am having a problem in that I have multiple values from different groups (there are 3 groups, and each group has multiple subjects, each with their own Y-value recorded for the same X-value, e.g. glucose of 25 (on Y axis) at month 0). The problem is that my team leaders want to be able to see each individual point spread out along the X-axis, even though they have the same X value. Is there a way to do this? See the link below for a screenshot of what I'm working with. Essentially, I need to stretch the points out along the X-axis, so that the points are clumped together.

http://imageshack.us/photo/my-images...0619at934.png/
  #2   Report Post  
Junior Member
 
Posts: 1
Default

I am sorry I can't help with your problem but I would love to know how you made the chart you attached. I am trying to do the same in excel 2010 with a number of y-values that have a limited number of x-values and to organize them vertically like you show. Maybe I can help with your problem once I get to where you are.

Thanks!
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Multiple XY pairs in scatter plot Excel 2007 DSO Charts and Charting in Excel 3 April 3rd 23 10:42 AM
Scatter plot with multiple Y-values and same X value. Qcom12 Charts and Charting in Excel 0 June 18th 12 09:05 PM
Scatter plot with two data series having common x-values Gordon[_2_] Charts and Charting in Excel 2 October 3rd 07 08:36 PM
XY scatter plot with multiple data pairs for each variable gpotavin Charts and Charting in Excel 2 June 5th 06 08:45 PM
BUG?: Excel scatter chart: will not plot x-values Bob Excel Discussion (Misc queries) 2 December 31st 04 01:19 AM


All times are GMT +1. The time now is 04:03 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"