+ Reply to Thread
Results 1 to 2 of 2

Create Multiple Straight line chart with data being unique data time marks on each line

  1. #1
    Registered User
    Join Date
    12-30-2012
    Location
    Quad Cities, Illinois
    MS-Off Ver
    Excel 2007
    Posts
    1

    Question Create Multiple Straight line chart with data being unique data time marks on each line

    Hello,

    I am trying to create a chart from data collected on numerous 24 hour days,
    up to 50 days.

    Each day's data is an event that occurs randomly during the day, up to 20 times.

    Each day could be depicted by a single straight line with tic marks at each data
    point for that day. Lines beside each other would allow occurrence trends to be
    seem.
    Sample Data

    Days 1st 2nd 3d
    4:00 1:00 7:55
    5:25 3:25 8:20
    12:25 8:40 9:55
    13:45 11:30 14:35
    17:00 15:50 18:20
    19:20 20:45 20:30
    22:00 21:25 22:45
    21:55 23:15
    23:45

    Thanks for any help on this question. There may be other ways to show the data.
    This is my first post, I hope it is OK.

    Excel Beginr

  2. #2
    Forum Contributor dogberry's Avatar
    Join Date
    07-15-2012
    Location
    Wales, UK
    MS-Off Ver
    Excel 2010
    Posts
    624

    Re: Create Multiple Straight line chart with data being unique data time marks on each lin

    Hi

    Can you post a sample worksheet so we can see the layout etc dont post confidental information
    it will also get you a much better response.


    To Attach a File:

    1. Click on Go Advanced
    2. In the frame Attach Files you will see the button Manage Attachments
    3. Click the button.
    4. A new window will open titled Manage Attachments - Excel Forum.
    5. Click the Browse... button to locate your file for uploading.
    6. This will open a new window File Upload.
    7. Once you have located the file to upload click the Open button. This window will close.
    8. You are now back in the Manage Attachments - Excel Forum window.
    9. Click the Upload button and wait until the file has uploaded.
    10. Close the window and then click Submit.



    Chris
    Click my star if I helped 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