+ Reply to Thread
Results 1 to 5 of 5

graphing non-contiguous data

  1. #1
    Registered User
    Join Date
    08-27-2013
    Location
    santa cruz, california
    MS-Off Ver
    Excel 2010
    Posts
    10

    graphing non-contiguous data

    I am collecting data readings from a kiln on a daily basis. I have 10 measurements in each of these daily records some of which are entered data and some of which are derived.
    I would like to have a day by day line for one of the measurements for each of the samples (so there would be 10 different graphs with 8 lines each.) Alternatively, I’d like to have a day by day line charts for all of the measurements for one of the samples (so there would be 8 different graphs with 10 lines each.)
    So either there needs to be a way to graph data from elements which are separated by n rows or m columns, or there needs to be a way to copy data that is separated by n rows or m columns into a compact array. Obviously, I could do this last method manually but this would be very labor intensive and error prone as the real records can cover as many as 150 days rather than the 3 days in the attached example.
    Attached Files Attached Files

  2. #2
    Forum Expert dflak's Avatar
    Join Date
    11-24-2015
    Location
    North Carolina
    MS-Off Ver
    365
    Posts
    7,920

    Re: graphing non-contiguous data

    What data do you want to plot, and what do you want the sample chart to look like? If you can provide a dummied-up sample, it will help a lot.
    One spreadsheet to rule them all. One spreadsheet to find them. One spreadsheet to bring them all and at corporate, bind them.

    A picture is worth a thousand words, but a sample spreadsheet is more likely to be worked on.

  3. #3
    Registered User
    Join Date
    08-27-2013
    Location
    santa cruz, california
    MS-Off Ver
    Excel 2010
    Posts
    10

    Re: graphing non-contiguous data

    I've attached an updated spreadsheet that shows one of each of the graph types. I've done this by manually copying the data in a contiguous matrix for one of each of the graph types.
    Hopefully this shows what I want. I'm just hoping to avoid copying each of the cells manually to the more easily graphed format
    thanks
    dave
    Attached Files Attached Files

  4. #4
    Forum Expert teylyn's Avatar
    Join Date
    10-28-2008
    Location
    New Zealand
    MS-Off Ver
    Excel 365 Insider Fast
    Posts
    11,372

    Re: graphing non-contiguous data

    Hello,

    The following will work if you continue to use the same 14 column pattern for each day. In cell G18 use

    =INDEX(6:6,((COLUMN(A1)*14)+6)-14)

    copy down for all samples and then across for as many days that you need.

    In cell G33 use this formula

    =INDEX($6:$6,(((ROW(A1)*14)+6)-14)+COLUMN(A1)-1)

    Copy across for M2 to M10 and then copy down for as many days as you need.

  5. #5
    Registered User
    Join Date
    08-27-2013
    Location
    santa cruz, california
    MS-Off Ver
    Excel 2010
    Posts
    10

    Re: graphing non-contiguous data

    perfect! I can see that it works and I think I see how to modify it for the other graphs that I need but I don't fully understand the syntax. I'll check out a some online tutorials for the index function.

    thank you very much

    dave

+ 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. Pulling non-contiguous data into a contiguous set.
    By blake.thompson in forum Excel General
    Replies: 4
    Last Post: 12-10-2015, 05:49 PM
  2. Copy contiguous columns and paste as non-contiguous
    By absconditus in forum Excel General
    Replies: 1
    Last Post: 12-29-2014, 03:17 AM
  3. [SOLVED] Using scripting dictionary to add contiguous group of items from non contiguous range
    By stnkynts in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 11-29-2014, 06:12 PM
  4. [SOLVED] How to sum non-contiguous columns applied as a formula on contiguous cells
    By figo12 in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 10-09-2013, 01:07 PM
  5. [SOLVED] How to delete multiple contiguous (and/or) non-contiguous rows, in an excel table
    By jimmalk in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 12-03-2012, 05:48 AM
  6. Copy and Paste an array (contiguous & non contiguous ranges)
    By Xrull in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 05-09-2010, 09:17 AM
  7. large non contiguous data set
    By bhofsetz in forum Excel Charting & Pivots
    Replies: 3
    Last Post: 05-25-2005, 12:30 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