+ Reply to Thread
Results 1 to 2 of 2

Thread: Time Graph

  1. #1
    Registered User
    Join Date
    03-10-2008
    Posts
    21

    Time Graph

    I have tried several graphs and cannot find one that will show me what I need. I have attached a spreadsheet to help. I have a list of various times throughout the day. I need a graph that will show the points on a scale from 7:00 AM to 7:00 PM. Or like: 7:00 AM - 10:00 AM, 10:00 AM - 1:00 PM, 1:00 PM - 4:00PM, 4:00 PM - 7:00PM.

    Please Help! Thanks!
    Attached Files Attached Files

  2. #2
    Forum Guru
    Join Date
    08-05-2004
    Location
    NJ
    MS-Off Ver
    MS 2007
    Posts
    4,972
    I'm not sure if you're looking to map these data points by grouping the hours by 3 and then you have some value you want to chart or if you want the # of occurences within each time range or if you want to separate by day.

    Excel's basic charting/graphing functions do minimal data manipulation. You need to manipulate the numbers before you chart. Pivot tables do some manipulation.

    I tried using grouping in Pivot tables but (at least in Excel 2000) you can't group in sets of 3 hours, just single hours (see attached). Then I set up a table and using SUMPRODUCT, manipulated the data that way. For # of occurrences within each range
    Code:
    =SUMPRODUCT(--($A$2:$A$35>=D2)*--($A$2:$A$35<=E2))
    For Average data values
    Code:
    =SUMPRODUCT(--($A$2:$A$35>=D2)*--($A$2:$A$35<=E2)*$B$2:$B$35)/SUMPRODUCT(--($A$2:$A$35>=D2)*--($A$2:$A$35<=E2))
    Then I graphed that table.

    Maybe I can help more after you've clarified my first question.

    ChemistB
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. w/ Line graph with time on X and missing data
    By matlack in forum Excel Charting
    Replies: 1
    Last Post: 10-17-2007, 12:49 PM
  2. Date and Time Graphs
    By sach0025 in forum Excel Charting
    Replies: 7
    Last Post: 03-10-2007, 01:07 AM
  3. using date & time in the x axis of a graph
    By sjhonny in forum Excel General
    Replies: 2
    Last Post: 01-18-2007, 09:39 AM
  4. Assignment overDUE PLEASE PLEASE HELP!!
    By undergrad in forum Excel Worksheet Functions
    Replies: 2
    Last Post: 11-29-2006, 12:34 AM
  5. Making a Graph that shows Frequency based on time
    By jamboc in forum Excel Charting
    Replies: 5
    Last Post: 11-12-2006, 11:38 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.2.0