+ Reply to Thread
Results 1 to 2 of 2

Plot a scatter chart indicating coincident points using Excel

  1. #1
    Registered User
    Join Date
    Valladolid, Spain
    MS-Off Ver

    Question Plot a scatter chart indicating coincident points using Excel


    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:


  2. #2
    Forum Guru
    Join Date
    North America
    MS-Off Ver
    2002/XP and 2007

    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.
    Quote Originally Posted by shg
    Mathematics is the native language of the natural world. Just trying to become literate.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Tags for this Thread


Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1