+ Reply to Thread
Results 1 to 3 of 3

trouble creating a chart with default output from a program. [excel 2003]

  1. #1
    Registered User
    Join Date
    10-26-2009
    Location
    San Matro, CA
    MS-Off Ver
    Excel 2003
    Posts
    1

    trouble creating a chart with default output from a program. [excel 2003]

    I am trying to chart some data that is output by an application, following is the basic format of the data. Any help would be appreciated.

    I am trying to do a line chart or a scatter chart with the data points connected where on the X axis "DATA1" would be one line, "DATA2" would be another line, and the date/time would be on the Y axis.

    Date,Time,extra data(do not graph),Data Name,Data Point(seconds)

    eg.

    "2009/10/26","15:30:50","extradata","DATA1","3.937"
    "2009/10/26","15:30:54","extradata","DATA2","3.391"
    "2009/10/26","15:31:0","extradata","DATA3","4.797"
    "2009/10/26","15:31:2","extradata","DATA4","1.953"
    "2009/10/26","15:31:4","extradata","DATA5","2.093"
    "2009/10/26","15:31:8","extradata","DATA6","3.469"
    "2009/10/26","15:31:12","extradata","DATA7","4.438"
    "2009/10/26","15:31:30","extradata","DATA8","17.813"
    "2009/10/26","15:31:31","extradata","DATA9","0.671"
    "2009/10/26","15:31:33","extradata","DATA1","0.531"
    "2009/10/26","15:31:35","extradata","DATA2","1.937"
    "2009/10/26","15:31:40","extradata","DATA3","3.313"
    "2009/10/26","15:31:42","extradata","DATA4","1.813"
    "2009/10/26","15:31:44","extradata","DATA5","1.562"
    "2009/10/26","15:31:48","extradata","DATA6","4.453"
    "2009/10/26","15:31:52","extradata","DATA7","3.922"
    "2009/10/26","15:32:1","extradata","DATA8","9.5"
    "2009/10/26","15:32:2","extradata","DATA9","0.484"
    "2009/10/26","15:32:4","extradata","DATA1","0.563"
    "2009/10/26","15:32:6","extradata","DATA2","1.782"
    "2009/10/26","15:32:10","extradata","DATA3","2.36"
    "2009/10/26","15:32:11","extradata","DATA4","1.672"
    "2009/10/26","15:32:13","extradata","DATA5","1.25"
    "2009/10/26","15:32:16","extradata","DATA6","3.25"
    "2009/10/26","15:32:20","extradata","DATA7","3.891"
    "2009/10/26","15:32:29","extradata","DATA8","9.313"
    "2009/10/26","15:32:30","extradata","DATA9","0.562"

    (BTW, I am a total excel newbie, so sorry if the question is a: too easy, or b: doesn't make sense)
    Last edited by almus; 10-26-2009 at 07:13 PM. Reason: Title did not describe problem.

  2. #2
    Forum Guru shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2003, 2010
    Posts
    40,653

    Re: Hopefully easy chart problem. [excel 2003]

    Welcome to the forum.

    Please take a few minutes to read the forum rules, and then amend your thread title accordingly.

    I'll move the thread to the charting forum.

    Thanks.
    Entia non sunt multiplicanda sine necessitate

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

    Re: trouble creating a chart with default output from a program. [excel 2003]

    You will need to change the layout/format of your data.

    Date and time need to be combined into a single date value.
    You need to output each DATAn value in a separate column.
    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)

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