View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.charting
Bernard Liengme[_3_] Bernard Liengme[_3_] is offline
external usenet poster
 
Posts: 1,104
Default 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.