+ Reply to Thread
Results 1 to 1 of 1

Graphing a time series of several tracked objects

Hybrid View

  1. #1
    Registered User
    Join Date
    05-09-2008
    Posts
    9

    Graphing a time series of several tracked objects

    Hi, Last time I visited was 6 years ago! Glad to see it is still a thriving community. Now, to business:

    (I have Excel 2010)

    Basically, what I am doing is checking (every 5 minutes) the value of three things and I want a graph showing me each
    thing's progress (or regress or plateau) during the time I am sampling.

    My data looks like this:

    Poll Time Name size
    1 15:35 one 110
    1 15:35 two 500
    1 15:35 three 26
    2 15:40 one 120
    2 15:40 two 500
    2 15:40 three 57
    3 15:45 one 130
    3 15:45 two 500
    3 15:45 three 13

    "Poll" is the id of each sampling, it is consecutive, starting from 1.
    Time is the current time. It is exactly 5 minutes between polls.

    One, two and three is a simplification. In reality, they are about 200. I do not want to manually add them.

    I tried different things, could not get it. Ideally, the graph I will have will be of
    three lines (one, two, three), the Y axis would the the size, the X axis would be
    the time (I don't need labels, just to see if there's an incline or decline trend).

    Thanks
    Last edited by Mustey; 10-20-2014 at 12:52 PM.

+ 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] Graphing A Time Series of Multiple Stock Prices
    By Alex in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 09-06-2005, 06:05 AM
  2. [SOLVED] Graphing A Time Series of Multiple Stock Prices
    By Alex in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 09-06-2005, 04:05 AM
  3. [SOLVED] Graphing A Time Series of Multiple Stock Prices
    By carl in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-05-2005, 11:05 PM
  4. Graphing a Time Series of Several Options
    By carl in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 07-02-2005, 11:05 AM
  5. Graphing A Time Series OF Stocks
    By carl in forum Excel Charting & Pivots
    Replies: 6
    Last Post: 06-27-2005, 08: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