How can i see if two points share a coordiante in a scatter graph?

[cmeakin]

I've plotted a scatter graph but i know that some of the data repeats, i.e.
there would be more than one point at a certain coordinate.
How can i get excel to show how many points there are?

 

[Shane Devenshire]

Hi,

1. create a new column in your data area which counts the number of repeats
for each point.
2. use the xlChartLabeler tool to attach these as data labels to your points.
This is a free download from
http://www.appspro.com/Utilities/ChartLabeler.htm