On a scatter chart show two point have same value

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have created a scatter chart, but often where only one point is shown on
the graph, it actually represents two or more points with the same values.
How can I show this on the chart?
 
You could add a couple of columns to your data, and create a bubble
chart. For example, if your values are in cells A2:B50 --

In D2, enter a formula to concatenate the values: =A2&"-"&B2
In C2, enter a formula to count the occurrences of each combination:
=COUNTIF($D$2:$D$50,D2)

Copy the formulas down to the last row of data

Select columns A:C and create a bubble chart.
 
Back
Top