Scatterplot Duplicate Values Charting Help (URGENT!!!) GMAIL invite offer inside

  • Thread starter Thread starter kevinL
  • Start date Start date
K

kevinL

Sorry to be so rude in the title but I'm making a scatterplot in Exce
and I have XY values like (1,4), (1,3.5), and (1,4). When I plot the
with the scatterplot wizard, the (1,4)s are indistinguishable. I'd lik
Excel to differentiate them. Any help would be GREATLY appreciated. I'l
throw in a gmail invite for anyone who can do this for me. . I've bee
using Photoshop to paste numbers next to the points and this is reall
tedious. THANKS
 
Two methods employing datalabels come to mind.

The first replaces the normal marker with a count of the frequency.

Suppose your data are in columns A and B starting with row 1. Also,
suppose the largest y value (in column B) is <100.

Then, in C1 array enter the formula =IF(SUM(N($A$1:A1*100+$B$1:B1=A1*
100+B1))<>SUM(N($A$1:$A$3*100+$B$1:$B$3=A1*100+B1)),"",SUM(N($A$1:$A$3*
100+$B$1:$B$3=A1*100+B1))) Copy C1 as far down column C as needed.
Plot A:B. Use XY Chartlabeler (www.appspro.com) or J-Walk Chart Tools
(www.j-walk.com) to label the series using the values in column C.
Remove the markers and center the data labels.

The other labels only those points where multiple datapoint overlap.

It's easiest to use a helper column. In E1 array enter =SUM(N($A$1:A1*
100+$B$1:B1=A1*100+B1)) In F1 array enter =IF(OR(E1=1,E1<>MAX(SUM(N($A
$1:$A$3*100+$B$1:$B$3=A1*100+B1)))),"",E1) Copy E1:F1 as far down as
needed. Use column F as the datalabel source for one of the above
mentioned programs. This time leave the marker visible and position
the datalabel next to it (above, below, whatever appeals to you).

--
Regards,

Tushar Mehta
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions
 
Back
Top