A Microsoft Excel forum. ExcelBanter

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » ExcelBanter forum » Excel Newsgroups » Charts and Charting in Excel
Site Map Home Register Authors List Search Today's Posts Mark Forums Read Web Partners

Scatter plot with multiple Y-values and same X value.



 
 
Thread Tools Display Modes
  #1  
Old June 19th 12, 02:44 PM
Qcom12 Qcom12 is offline
Junior Member
 
First recorded activity by ExcelBanter: Jun 2012
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/
Ads
  #2  
Old August 2nd 12, 03:54 AM
Ratnose86 Ratnose86 is offline
Junior Member
 
First recorded activity by ExcelBanter: Aug 2012
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!
 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Scatter plot with multiple Y-values and same X value. Qcom12 Charts and Charting in Excel 0 June 18th 12 09:05 PM
Multiple XY pairs in scatter plot Excel 2007 DSO Charts and Charting in Excel 2 October 24th 07 05:13 AM
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 12:19 AM


All times are GMT +1. The time now is 06:19 AM.


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