+ Reply to Thread
Results 1 to 3 of 3

Scatter diagram with labels for each 'point' in the scatter

  1. #1
    Registered User
    Join Date
    09-01-2010
    Location
    london
    MS-Off Ver
    Excel 2003
    Posts
    11

    Scatter diagram with labels for each 'point' in the scatter

    Hi
    I have been trying to highlight a series of cells & get Excel to draw a scatter diagram, where each point on the scatter ( i.e. a group of two numbers...eg 2, 9 ) can show the label name. I want every point in the scatter to have a unique name.

    However Exel only allows me to show the series name against each point & not the unique name thats shown on the worksheet ( eg...London rainfall, or Manchester rainfall ).

    I found that I can acheive this using a separate data-series for each 'point', but its a very manual solution, as its necessary to enter the three peices of data one by one. I cant find a way to simply highlight my data range & have excel assign cell A as the 'point name', cell B as the first data point & cell C as the second data point in a long series of similar cells.

    Any thoughts ?

  2. #2
    Forum Guru shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2003, 2010
    Posts
    40,655

    Re: Scatter diagram with labels for each 'point' in the scatter

    Welcome to the forum.

    See http://www.appspro.com/Utilities/ChartLabeler.htm
    Entia non sunt multiplicanda sine necessitate

  3. #3
    Registered User
    Join Date
    09-01-2010
    Location
    london
    MS-Off Ver
    Excel 2003
    Posts
    11

    Re: Scatter diagram with labels for each 'point' in the scatter

    Thanks - would be great if our work PC's were not locked-down to prevent use of unauthorised software.
    Thanks anyway.

    Cheers

+ 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