+ Reply to Thread
Results 1 to 2 of 2

Plot a scatter chart indicating coincident points using Excel

  1. #1
    Registered User
    Join Date
    06-08-2019
    Location
    Valladolid, Spain
    MS-Off Ver
    365
    Posts
    1

    Question 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

  2. #2
    Forum Guru
    Join Date
    04-13-2005
    Location
    North America
    MS-Off Ver
    2002/XP and 2007
    Posts
    15,803

    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)

Similar Threads

  1. Identifying Points in a Scatter Plot
    By jbianco51 in forum Hello..Introduce yourself
    Replies: 1
    Last Post: 08-20-2014, 04:42 PM
  2. Adding Labels to Data Points in Scatter Plot Chart
    By Stopea in forum Excel General
    Replies: 10
    Last Post: 05-21-2014, 08:25 PM
  3. Replies: 0
    Last Post: 03-20-2013, 05:51 PM
  4. Plot points on a area chart or plot areas on a scatter chart
    By maggy in forum Excel Charting & Pivots
    Replies: 4
    Last Post: 01-17-2012, 04:39 AM
  5. xy scatter plot scroller chart-lines joining up points
    By sport_logo in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 05-15-2010, 12:30 PM
  6. Only plot scatter points that have both an X and a Y value (2007)
    By JayUSA in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 06-15-2009, 04:23 AM
  7. [SOLVED] Scatter plot points x and y coordinates
    By Milo in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 11-28-2005, 07:25 PM

Tags for this Thread

Bookmarks

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