scatter graph repeated coordinate

C

cmeakin

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.
 
B

Bernard Liengme

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
 
Top