scatter graph repeated coordinate
 

How do i get excel to show if a particular coordinate is repeated? It seems
to display the coordinate labels in varying colours depending on how many
times it is repeated, but i'd like to know exactly how many times.

scatter graph repeated coordinate
 

Possible solution
Let the chart data be in A2:B11
In C2 enter =SUMPRODUCT(--($A$2:$A$11=A2),--($B2:$B11=B2))
Copy down the column
This will count how many point have the same (x,y) values
Use a chart labeler add-in to use the C values for data labels
Rob Bovey's XY Chartlabeler (www.appspro.com)
or John Walkenbach's Chart Tools (www.j-walk.com).
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email


"cmeakin" wrote in message
...
How do i get excel to show if a particular coordinate is repeated? It
seems
to display the coordinate labels in varying colours depending on how many
times it is repeated, but i'd like to know exactly how many times.