scatter graph repeated coordinate

  • Thread starter Thread starter cmeakin
  • Start date Start date
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.
 
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
 
Back
Top