+ Reply to Thread
Results 1 to 10 of 10

Line graph with varying x ad y axis values

  1. #1
    Registered User
    Join Date
    07-13-2012
    Location
    Canada
    MS-Off Ver
    Excel 2003
    Posts
    9

    Line graph with varying x ad y axis values

    Hello,

    I have been struggling to draw a line chart, can you help me. My data looks like this.

    Time September 21, 2012 Time September 24, 2012 Time September 25, 2012
    0:13 113.25 3:53 116 0:02 85.25
    0:17 110.25 3:57 72.5 0:03 78.75
    0:18 88.125 4:19 166.5 0:04 82.125
    0:20 77.25 4:44 163.75 0:10 107.75
    0:21 74 4:45 80.25 0:11 77.25
    0:28 93.5 6:10 905.5 0:14 94.25
    0:29 78.25 6:11 921.3333333 0:15 76.25
    0:39 84.08333333 6:45 187.5 0:16 77.5
    0:40 78.25 6:46 146.25 0:19 143
    0:41 79.625 6:47 152.75 0:20 72.8
    0:58 101.25 6:49 206.75 0:24 83
    1:14 104 6:50 122.75 0:34 103
    1:15 79 6:53 181.25 0:35 84
    1:28 92.75 6:54 151 0:43 105.75
    1:29 77.5 6:55 224.75 1:05 115
    1:36 94 6:56 118 1:14 110.75
    1:41 98.25 7:03 124.75 1:16 185.5
    1:42 79.5 7:04 143.3333333 1:19 144
    3:06 200 7:05 174 1:20 146.625
    3:07 75.54545455 7:10 285.75 1:21 89.5
    3:32 99.25 7:11 189.5 1:22 80.375
    3:37 77 7:13 279.5 1:27 81.25



    Here Time range is from 00:00 to 23:59. So its the request statistics for each day at each time interval.

    I want to draw one single line graph - Statistics Vs Time(X) - including all these data and separate it by series like 1 series for Sept 24, 2012 and one for Sept 25, 2012 and so on.

    Can you help me with this ?

  2. #2
    Forum Expert
    Join Date
    06-09-2010
    Location
    Australia
    MS-Off Ver
    Excel 2013
    Posts
    1,690

    Re: Line graph with varying x ad y axis values

    Hi
    are you numbers in adjacent columns, or a single text string in successive rows in one column?

  3. #3
    Forum Expert
    Join Date
    06-09-2010
    Location
    Australia
    MS-Off Ver
    Excel 2013
    Posts
    1,690

    Re: Line graph with varying x ad y axis values

    is this what you're after? it's an xy scatter graph with time on the x axis
    Attached Files Attached Files

  4. #4
    Registered User
    Join Date
    07-13-2012
    Location
    Canada
    MS-Off Ver
    Excel 2003
    Posts
    9

    Re: Line graph with varying x ad y axis values

    Exactly,thats what I want. how did you do it.

  5. #5
    Forum Expert
    Join Date
    06-09-2010
    Location
    Australia
    MS-Off Ver
    Excel 2013
    Posts
    1,690

    Re: Line graph with varying x ad y axis values

    Hi
    using the xy format allows the x axis to be scaled as numerical values (in this case, time values). It also allows you to enter unique x-values for each series. So the x-values are in range A3:A24 for the first series, C3:C24 for the second, etc.

  6. #6
    Registered User
    Join Date
    07-13-2012
    Location
    Canada
    MS-Off Ver
    Excel 2003
    Posts
    9

    Re: Line graph with varying x ad y axis values

    But friend, I tried to do the same using scatter chart. But I can see the x-axis time ranges from 00:00 to 4:48. Not sure why. It has to end at 23:59. I attached TestNew.xlsthe sample data and my diagram. Please check.

  7. #7
    Registered User
    Join Date
    07-13-2012
    Location
    Canada
    MS-Off Ver
    Excel 2003
    Posts
    9

    Re: Line graph with varying x ad y axis values

    Any idea on this Nicky ?

  8. #8
    Forum Guru
    Join Date
    04-13-2005
    Location
    North America
    MS-Off Ver
    2002/XP and 2007
    Posts
    13,034

    Re: Line graph with varying x ad y axis values

    When you don't like Excel's default choices for axis limits, then you need to manually select the axis limits you want. Right click on the x axis, select "format axis", on the scale tab enter the desired values for max and min (recognizing that, using the built in time/date serials, these numbers will be "number of days since Jan 1901"). You also may need to adjust the number format for the axis to get it to show 24:00 at the maximum.

  9. #9
    Forum Expert
    Join Date
    06-09-2010
    Location
    Australia
    MS-Off Ver
    Excel 2013
    Posts
    1,690

    Re: Line graph with varying x ad y axis values

    Hi samjna
    I think MrShorty's answer solves your problem.
    is this what you want?
    Attached Files Attached Files

  10. #10
    Registered User
    Join Date
    07-13-2012
    Location
    Canada
    MS-Off Ver
    Excel 2003
    Posts
    9

    Re: Line graph with varying x ad y axis values

    Yes till 23:99. I just unchecked Max field and added 0.99 to it. It worked, Thank you.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Tags for this Thread

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