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
|
|||
|
|||
all points on a xy graph
Thanks to people's answers I have managed to create a basic correlation
scattergram. I only have 18 participants, each with two values to correlate. However if two participants have the same results only one point is shown. Therefore my scattergram only shows eight points when there are 18 values. Does that make sense? If I was doing it manually I would simply put two marks where two participants fall, pretty simple, but can't find how to do this in excel. Any help would be great. |
#2
|
|||
|
|||
all points on a xy graph
A surface plot may help. It can be used to show the frequency of
occurrence of data pairs. HTH, John |
#3
|
|||
|
|||
all points on a xy graph
Stressed -
You could use a manual method of "jittering." For the data set being plotted, where there are two identical values, change the worksheet values of either X or Y or both slightly so that two markers will appear. - Mike www.mikemiddleton.com "Stressed Dissertation Author" Stressed Dissertation wrote in message news Thanks to people's answers I have managed to create a basic correlation scattergram. I only have 18 participants, each with two values to correlate. However if two participants have the same results only one point is shown. Therefore my scattergram only shows eight points when there are 18 values. Does that make sense? If I was doing it manually I would simply put two marks where two participants fall, pretty simple, but can't find how to do this in excel. Any help would be great. |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
missing data points causes my line graph not to connect | liebw | Charts and Charting | 8 | November 24th, 2008 10:15 PM |
Connecting Points In An XY-Scatter Plot Graph | Adam WK | Charts and Charting | 2 | April 9th, 2006 07:05 PM |
joining data points on graph | minihana | Charts and Charting | 2 | February 12th, 2006 02:02 AM |
How do I add data points to a line graph? | Archer | Visio | 1 | January 23rd, 2006 01:02 AM |
graph does not show all plotted points | adele | Charts and Charting | 0 | August 30th, 2005 03:05 PM |