+ Reply to Thread
Results 1 to 3 of 3

Scatter plot data points as text not standard blue squares?

  1. #1
    Registered User
    Join Date
    12-02-2013
    Location
    London
    MS-Off Ver
    Excel 2010
    Posts
    19

    Scatter plot data points as text not standard blue squares?

    Is there any way to make a scatter plot's data points reference and show as text from another cell? Not the actual value of the point but just the label? As opposed to the text being next the the point, i want the point to be text itself.

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

    Re: Scatter plot data points as text not standard blue squares?

    This procedure should be a start for you (http://www.exceldashboardtemplates.c...hboard-charts/) Replace picture or clip art with a text box containing the desired text.

    The additional challenge will be to link the text in a cell to the text in the text box (or boxes) and then have that link through to the custom marker box.
    Quote Originally Posted by shg
    Mathematics is the native language of the natural world. Just trying to become literate.

  3. #3
    Forum Guru Andy Pope's Avatar
    Join Date
    05-10-2004
    Location
    Essex, UK
    MS-Off Ver
    O365
    Posts
    20,434

    Re: Scatter plot data points as text not standard blue squares?

    Can you not use data labels?
    Cheers
    Andy
    www.andypope.info

+ 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. Representing same data points in a scatter plot
    By Chandelia in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 12-03-2009, 05:54 AM
  2. Excel 2007 : Labelling Data Points on a Scatter Plot
    By SDruley in forum Excel General
    Replies: 3
    Last Post: 06-01-2009, 09:56 AM
  3. Automate Scatter Plot with data points being numbers
    By Grateful in forum Excel Charting & Pivots
    Replies: 4
    Last Post: 02-24-2009, 12:27 PM
  4. How do i show duplicate data points on a scatter plot?
    By Mr.Man in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 01-30-2006, 11:10 AM
  5. how to add data points to a scatter plot with trend line
    By Samantha in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 02-28-2005, 09:06 AM

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