+ Reply to Thread
Results 1 to 2 of 2

How to plot a single column of data in multiple series based on date

  1. #1
    Registered User
    Join Date
    05-27-2013
    Location
    Washington, DC
    MS-Off Ver
    Excel 2016
    Posts
    15

    How to plot a single column of data in multiple series based on date

    I don't post on here very often, but I have tried searching, and I can't seem to find an answer for my issue. I'm going to post a hypothetical, but it matches my real-world situation very closely.

    Say I've got the following set of data relating to individual observations of travel delay on a highway segment throughout the course of a day:

    DATE; DELAY; TIME
    1/22/14; 3.0; 06:00
    1/22/14; 3.7; 09:00
    1/22/14; 4.4; 11:00
    1/23/14; 2.7; 06:45
    1/23/14; 1.6; 13:28
    1/24/14; 8.9; 05:45
    1/24/14; 7.5; 09:34
    1/24/14; 3.8; 14:56
    1/24/14; 5.0; 15:18

    I am interested in splitting this data by date, and plotting a separate series for each day, all on the same graph. So, in this case, there would be a total of 3 series, where Time is plotted on the horizontal axis, and Delay is plotted on the vertical axis.

    Is there a way to easily split this data for plotting as multiple series? My problem arises in that my actual data set contains dozens of different days, each of which have hundreds of observations. Copying and pasting each day into a separate column is cost-prohibitive (time-wise), and I can't help but think there's got to be some clever way to use indicators or something to get the plots I need.

    I am relatively new to working with large data sets in Excel, so any help or advice is appreciated!

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

    Re: How to plot a single column of data in multiple series based on date

    You can create a pivot table/chart.

    Note the time will be a category rather than a value. In order to be a value you would need to create a xy-scatter chart but you can not use pivot chart for xy-scatter.
    Attached Files Attached Files
    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. How to plot a single continuous line with data from multiple row/column?
    By crease123 in forum Excel Charting & Pivots
    Replies: 4
    Last Post: 01-02-2013, 05:48 PM
  2. Replies: 1
    Last Post: 08-02-2012, 03:58 AM
  3. How can I plot multiple data set on a single contour plot
    By hafziebone in forum Excel General
    Replies: 0
    Last Post: 02-11-2012, 02:02 PM
  4. How can I plot multiple data set on a single contour plot
    By hafziebone in forum Excel General
    Replies: 0
    Last Post: 02-10-2012, 11:27 PM
  5. [SOLVED] chart data series -- plot a table as a single series
    By hjc in forum Excel Charting & Pivots
    Replies: 7
    Last Post: 09-20-2005, 01:05 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