+ Reply to Thread
Results 1 to 2 of 2

Displaying information from scatter plots

  1. #1
    Registered User
    Join Date
    06-20-2016
    Location
    Edinburgh, Scotland
    MS-Off Ver
    2013
    Posts
    4

    Displaying information from scatter plots

    Hi,

    Im sure this has already been answered, but if anyone could help any extra that would be great thanks.

    My situation is as follows


    Town______Population______ Shops
    Uist_________3000___________ 4
    Bradie______16000___________13
    St Tom_____12500___________ 10

    If I am displaying Population vs Shops in a scatter plot, how would I know which point is Uist or Bradie or St Tom? Without actually manually looking up the info. This would be easy for the example above but my data set has many hundreds of points therefore a look up process would be time consuming. I would like to be able to click a point on the scatter plot and see what town I am looking at, usually for outliers on the dataset.


    Kind regards
    Alistair

  2. #2
    Forum Expert Crooza's Avatar
    Join Date
    10-19-2013
    Location
    Hunter Valley, Australia
    MS-Off Ver
    Excel 2003 /7/10
    Posts
    2,082

    Re: Displaying information from scatter plots

    Here's a macro to link the labels to the town name and I've also attached an example spreadsheet

    Please Login or Register  to view this content.
    Attached Files Attached Files
    Happy with my advice? Click on the * reputation button below

+ 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. cannot do scatter plots in Windows 8
    By seraphin in forum Microsoft Windows Help
    Replies: 6
    Last Post: 06-27-2014, 05:54 PM
  2. Zoom Box for XY Scatter Plots
    By geophysicist in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 08-20-2013, 10:07 AM
  3. stacked scatter plots
    By bored in forum Excel Charting & Pivots
    Replies: 7
    Last Post: 11-11-2010, 04:59 AM
  4. Combining Scatter Plots
    By TKL in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 01-05-2006, 12:10 PM
  5. [SOLVED] Excel gives me line plots - I want scatter plots
    By Pangloss in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 10-14-2005, 10:05 AM
  6. Scatter Plots
    By khazikani in forum Excel General
    Replies: 0
    Last Post: 04-02-2005, 03:16 PM
  7. Ellipses in scatter plots
    By rchris68 in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 03-15-2005, 12:06 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