Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
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
Posted to microsoft.public.excel.charting
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Should I use a scatter graph? | Excel Discussion (Misc queries) | |||
Should I use a scatter graph? | Charts and Charting in Excel | |||
Scatter Plot graph | Charts and Charting in Excel | |||
scatter graph | Charts and Charting in Excel | |||
XY scatter graph | Charts and Charting in Excel |