Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
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
Posted to microsoft.public.excel.charting
|
|||
|
|||
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
Posted to microsoft.public.excel.charting
|
|||
|
|||
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 ... 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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
missing data points causes my line graph not to connect | Charts and Charting in Excel | |||
Connecting Points In An XY-Scatter Plot Graph | Charts and Charting in Excel | |||
joining data points on graph | Charts and Charting in Excel | |||
label points on an XY graph | Charts and Charting in Excel | |||
graph does not show all plotted points | Charts and Charting in Excel |