In excel display multiple same value points on a scattergraph
 

I have a large amount of data to present in a scattergraph but this creates
many multiples of the same points. How can I display this on the
scattergraph so that it is clear how many data entries a point refers to?

In excel display multiple same value points on a scattergraph
 

In A1 and B1 I have labels: X and Y
In A2:A10 I have my x-values; in B2:B10 I have my y-values
Some of the (x,y) pairs are duplicates
I have an XY chart; all is the same as yours except for the size of the data
set (irrelevant)
In C2 I have the formula =SUMPRODUCT(--($A$2:$A$9=A2),--($B$2:$B$9=B2))
I use this data with Bovey hart Labeller (www.appspro.com) to label my
markers to show how many occurrences there are
If I want to avoid showing 1's I will use
=IF(SUMPRODUCT(--($A$2:$A$9=A2),--($B$2:$B$9=B2))1,SUMPRODUCT(--($A$2:$A$9=A2),--($B$2:$B$9=B2)),"")
best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"short one" <short wrote in message
...
I have a large amount of data to present in a scattergraph but this creates
many multiples of the same points. How can I display this on the
scattergraph so that it is clear how many data entries a point refers to?