If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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. |
#2
|
|||
|
|||
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. |
Thread Tools | |
Display Modes | |
|
|