# Plot a scatter chart indicating coincident points using Excel

1. ## Plot a scatter chart indicating coincident points using Excel

Hi!

I'm new in this forum. I'd thank you a lot if you help me. I have to plot two different variables which both can take only integer values from 1 to 5. I want to plot a scatter chart with one of the variables (let's call it X) in the X axis and the other (let's call it Y) in the Y axis. Due to the scarcity of possible values that the variables can take, I have some points (xi,yi) that coincide in the same place of the chart.

Is there any way to indicate the number of points that coincide in the same place? For example, if I have two points which are both in (4,3), I want that a number 2 (or x2) appears in that place of the chart. The only thing I find similar to what I want is to plot this type of chart wich let see more blue in the points that are repeated, but if the point is repeated more than twice, it's impossible to know if it is repeated twice, 3 times, or more.

This image shows what I want:

Captura1.png  Register To Reply

2. ## Re: Plot a scatter chart indicating coincident points using Excel

Two ideas:

1) Use data labels. You will need a formula that will count the number of times each point occurs (probably a COUNTIFS() function). Then use that column for custom data labels (https://support.office.com/en-us/art...2-f467c9f4eb2d ). This might want a completely separate table with the possible combinations and counting function rather than trying to do this in the raw data table.
2) Use a bubble chart (https://support.office.com/en-us/art...1-C766F3E330D9 ) -- where the size of each bubble can indicate how many times that point occurs. Again, you will need a COUNTIFS() function or similar to count the number of times each point occurs and this might prefer its own table rather than try to do it with the raw data.

As with many charting questions, most of the work is in the spreadsheet. Once the spreadsheet work is done, the chart itself should be easy to create.  Register To Reply

There are currently 1 users browsing this thread. (0 members and 1 guests) 