|
|||||||||||||||||||||
|
#1
|
|||
|
|||
|
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! |
|
#2
|
|||
|
|||
|
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)) 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)) Maybe I can help more after you've clarified my first question. ![]() ChemistB |
![]() |
| Bookmarks |
New topics in Excel Charting
|
|
|
| Currently Active Users Viewing This Thread: 1 (0 members and 1 guests) | |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| w/ Line graph with time on X and missing data | matlack | Excel Charting | 1 | 10-17-2007 12:49 PM |
| Date and Time Graphs | sach0025 | Excel Charting | 7 | 03-10-2007 01:07 AM |
| using date & time in the x axis of a graph | sjhonny | Excel Miscellaneous | 2 | 01-18-2007 09:39 AM |
| Assignment overDUE PLEASE PLEASE HELP!! | undergrad | Excel Worksheet Functions | 2 | 11-29-2006 12:34 AM |
| Making a Graph that shows Frequency based on time | jamboc | Excel Charting | 5 | 11-12-2006 11:38 PM |