![]() |
| 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. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
|
|||
|
|||
|
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
|
|||
|
|||
|
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 | |
|
|
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 |