+ Reply to Thread
Results 1 to 2 of 2

How to create Line chart by date. Newbie thank you

  1. #1
    Registered User
    Join Date
    06-07-2012
    Location
    Detroit, MI
    MS-Off Ver
    Excel 2003
    Posts
    1

    How to create Line chart by date. Newbie thank you

    I need to create a line chart (graph) that has 1,2,3,4,5,6 on y axis... dates over 1 year on x axis... And I have 10 seperate data lines to graph. (ie. sample#1, 2.5 in Jan., 3.7 in Feb, etc.... Sample #2, 1.4 in Jan, 2.1 in Feb, etc..) Thank you very much for your help. I really appreciate it!

    Here is the first 2 samples... They have different dates, it's not always the 1st of each month...

    10/19/2010 - 8.28
    11/19/2010 - 10.86
    12/28/2010 - 10.77
    2/1/2011 - 10.77
    3/8/2011 - 10.74
    4/14/2011 - 10.86
    5/20/2011 - 10.77
    6/21/2011 - 10.87
    8/3/2011 - 10.74
    9/6/2011 - 10.81
    10/11/2011 - 10.82

    and
    6/22/2011- 10.33
    8/2/2011 - 10.39
    9/7/2011 - 10.32
    10/12/2011 - 10.30
    11/16/2011 - 9.2
    1/14/2012 - 9.2
    2/21/2012 - 9.2
    3/28/2012 - 9.2
    5/2/2012 - 9.2
    Last edited by JerryLog; 06-07-2012 at 10:10 AM. Reason: more detail

  2. #2
    Forum Contributor
    Join Date
    08-22-2011
    Location
    Texas, United States
    MS-Off Ver
    Excel 2007 and 2010
    Posts
    516

    Re: How to create Line chart by date. Newbie thank you

    Jerry,

    Could you post your worksheet so that I may see what your full data set looks like. That will give me a better understanding of what you want to do.

    Thanks

+ 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