+ Reply to Thread
Results 1 to 3 of 3

Creating multi-series X,Y scatter plot with data organized as (series name, x, y)

  1. #1
    Registered User
    Join Date
    11-09-2013
    Location
    Monterey, CA
    MS-Off Ver
    Excel 2013
    Posts
    2

    Creating multi-series X,Y scatter plot with data organized as (series name, x, y)

    I am trying to create a x,y scatter plot of multiple series, each with their own x,y values. The data is organized as shown below (also see attached workbook), as "series name, x, y". I can create the scatter plot by adding each series to the chart using "select data", but there are hundreds of series and I need a faster way to go through it. Is there a way to input these three columns (or macros) so that excel can sort the data into series and graph it? (Using Excel 2013)

    series x y (also see attached workbook)
    a1 599885.304 4051177.368
    a1 599884.681 4051181.09
    a1 599884.618 4051181.697
    a2 599870.543 4051175.651
    a3 599854 4051171.144
    a3 599854.177 4051174.89
    a4 599839.572 4051177.898

    Thank you very much!

    turtlepower54
    Attached Files Attached Files

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

    Re: Creating multi-series X,Y scatter plot with data organized as (series name, x, y)

    One quick way is to use formula to lay the data out differently.

    Due to upload limits I have only populated a section of the sheet with formula, but you should get the idea.
    Attached Files Attached Files
    Cheers
    Andy
    www.andypope.info

  3. #3
    Registered User
    Join Date
    11-09-2013
    Location
    Monterey, CA
    MS-Off Ver
    Excel 2013
    Posts
    2

    Re: Creating multi-series X,Y scatter plot with data organized as (series name, x, y)

    Thank you! Very clear and perfect for what I'm doing with the data.

    Thanks again!
    Alex

+ 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. Macro to create scatter plot with different data series?
    By mglwd40 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 02-07-2013, 08:17 PM
  2. Combine data from several rows in one series in scatter plot
    By marikladd in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 12-07-2012, 08:11 AM
  3. Scatter Plot Series Name
    By streetboarder in forum Excel Charting & Pivots
    Replies: 9
    Last Post: 11-10-2011, 06:06 AM
  4. Scatter plot, multiple series (data) help!
    By LuckiCharmzXP in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 10-01-2011, 06:33 AM
  5. XY Scatter Plot Data Series Additions within a loop
    By jmikeviolin in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 08-16-2011, 11:08 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