Thread: Graph by Minute
View Single Post
  #3   Report Post  
Tushar Mehta
 
Posts: n/a
Default

The only practical solution would be to create a XY Scatter chart.

For any other kind of chart, you can use John Mansfield's solution but
each time sample will be spaced equidistant from its neighbors.

The only other solution would be to create the correct spacing by hand.
The required interval must accomodate all the time values you have. I
wouldn't be surprised if the only such interval is 1 minute. So, if
that is indeed the smallest acceptable interval, create:
3/25 22:00
3/25 22:01
3/25 22:02
3/25 22:03
....you get the idea.

Only those rows that correspond to real data would have data values in
the other columns.

Assuming your data set fits in the limit for the number of data points
in an XL series (16,536 I believe) use a 'category' type for the x-axis
and you will get what you want.

--
Regards,

Tushar Mehta
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions

In article ,
says...
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.