+ Reply to Thread
Results 1 to 4 of 4

Scatter Diagram?

  1. #1
    Registered User
    Join Date
    10-01-2008
    Location
    Cheshire
    Posts
    15

    Scatter Diagram?

    Hi all,

    I have tried to plot a graph I need using the scatter graph but I cannot achieve the desired result and wondered where I am going wrong.

    I have simplified my example to save explaining the data I am working with!

    Let's say I have a list of 10 peoples names and have recorded their height in CM and weight in KG. I want to plot the name of each individual on a chart by referencing their height off an x-axis and their weight off a y-axis. Where the two values intersect I would like a dot labelled with their name.

    I have tried doing this in Excel but keep getting a series of plots for weight and then a different set for height. Any idea how I get round this?

    Thanks,

    Paul

  2. #2
    Forum Expert teylyn's Avatar
    Join Date
    10-28-2008
    Location
    New Zealand
    MS-Off Ver
    Excel 365 Insider Fast
    Posts
    11,372

    Re: Scatter Diagram?

    Hi,

    you need to arrange your data in two columns:

    column label x - height
    column label Y - weight

    Then select the data without the labels and create an XY scatter chart.

    In a separate column, which could be adjacent/before the X column, enter the names. Then use the XY Chart Labeler add-in to associate the scatter chart data points with the names.

    The add-in can be downloaded here:

    http://www.appspro.com/Utilities/ChartLabeler.htm

    If you still have problems getting this to work, please post a sample workbook. I'm sure we can work it out

    cheers
    Last edited by teylyn; 12-18-2009 at 08:37 AM.

  3. #3
    Registered User
    Join Date
    10-01-2008
    Location
    Cheshire
    Posts
    15

    Re: Scatter Diagram?

    thanks for your response. still ahven't been able to manage it - I have uploaded a sample workbook.

    thanks!
    Attached Files Attached Files

  4. #4
    Forum Expert teylyn's Avatar
    Join Date
    10-28-2008
    Location
    New Zealand
    MS-Off Ver
    Excel 365 Insider Fast
    Posts
    11,372

    Re: Scatter Diagram?

    Hi,

    I downloaded and installed the add-in (2 minutes flat)
    I followed the steps in my previous post.

    see attached.
    Attached Files Attached Files

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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