+ Reply to Thread
Results 1 to 3 of 3

Creating multiple series chart without hand selecting each dataset

  1. #1
    Registered User
    Join Date
    08-12-2013
    Location
    USA
    MS-Off Ver
    Excel 2016, 32-bit
    Posts
    92

    Creating multiple series chart without hand selecting each dataset

    First time poster here. I've been working in Excel for awhile, but not with such large datasets. I'm starting to learn VBA also, but was looking to do this without it, if possible. After searching google, I don't think it's possible, but maybe you all can help me.

    Is there an easy way to create a chart with multiple series, but not actually put each of the series in manually?

    The problem is that I have 2 columns that I want to plot, but each series could be 1 point or many points. Each series is represented here by a letter (j,k,m,n) and then I'd like to plot (3,9) as if it were an (x,y) pair.

    The reason I would like to not select all these by hand is that there are about 100 different series (which I would not put all on the same graph) and I'm going to have to do this on multiple spreadsheets for different data sets.

    Thanks in advance!
    -njs27

    Book.xlsx
    Last edited by njs27; 08-23-2013 at 10:48 AM. Reason: ETA file

  2. #2
    Registered User
    Join Date
    08-12-2013
    Location
    USA
    MS-Off Ver
    Excel 2016, 32-bit
    Posts
    92

    Re: Creating multiple series chart without hand selecting each dataset

    I've written some rough pseudo code, maybe someone can help me turn this into a macro?

    I'm trying to capture x data and y data for each series in an array, so that I can use the SERIES function to graph them.

    Here's the code:
    Last edited by njs27; 08-26-2013 at 11:13 AM.

  3. #3
    Registered User
    Join Date
    08-12-2013
    Location
    USA
    MS-Off Ver
    Excel 2016, 32-bit
    Posts
    92

    Re: Creating multiple series chart without hand selecting each dataset

    I've written some rough pseudo code, maybe someone can help me turn this into a macro?

    I'm trying to capture x data and y data for each series in an array, so that I can use the SERIES function to graph them.

    Here's the code:

    Please Login or Register  to view this content.

+ 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. [SOLVED] Creating a simple chart with multiple series
    By emulcahy in forum Excel General
    Replies: 3
    Last Post: 08-13-2012, 03:41 PM
  2. Copying a dataset multiple times - and selecting titles for this dataset
    By alocke in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 02-07-2012, 10:15 PM
  3. creating a certain chart from a certain dataset
    By Jeff Kish in forum Excel General
    Replies: 0
    Last Post: 04-03-2006, 02:20 PM
  4. [SOLVED] Creating a High-Low-Close chart with multiple series?
    By The Chad in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 05-02-2005, 09:06 PM
  5. Creating a High-Low-Close chart with multiple series?
    By The Chad in forum Excel General
    Replies: 0
    Last Post: 05-02-2005, 06:06 PM

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