LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Lori
 
Posts: n/a
Default Graph by Minute

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Bar graph values keep changing Mike82j2000 Charts and Charting in Excel 1 January 6th 05 01:27 PM
Graph Axes Robin Excel Discussion (Misc queries) 0 December 8th 04 08:03 PM
Problem with graph ranges No Such Luck Charts and Charting in Excel 6 December 3rd 04 01:09 PM
Named dynamic ranges, copied worksheets and graph source data WP Charts and Charting in Excel 1 November 28th 04 05:19 PM
convert 100 minute hour to a 60 minute hour Todd Excel Worksheet Functions 1 November 15th 04 06:14 PM


All times are GMT +1. The time now is 09:44 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"