Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
I have a Excel 2000 spreadsheet were samples were taken randomly through the
day over several months. Some days only a couple samples, other days samples were taken several times an hour, and there were a variety "samples" taken. I completed pulling into Access, but that created more problems. As there are some 20 "types" that are sampled. Time Type 1 Type 2 Type 3 3/25/01 22:00 166 3/25/01 22:08 166 3/26/01 0:00 23 25 3/26/01 2:00 155 6 3/26/01 3:00 17 25 3/26/01 6:15 157 11 3/26/01 8:00 17 25 3/26/01 9:00 47 3/26/01 9:15 3 25 3/26/01 9:25 47 3/26/01 9:30 55 3 9 3/26/01 9:50 55 3/26/01 10:30 92 24 3/26/01 11:30 114 What I now need to do is create a graph that includes all the samples, however when I format at the X axis, I only have options for Days, Months and Years I'm not being allowed to choose by minute. Any help would be appreciated. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Bar graph values keep changing | Charts and Charting in Excel | |||
Graph Axes | Excel Discussion (Misc queries) | |||
Problem with graph ranges | Charts and Charting in Excel | |||
Named dynamic ranges, copied worksheets and graph source data | Charts and Charting in Excel | |||
convert 100 minute hour to a 60 minute hour | Excel Worksheet Functions |