Hi everyone,

I know i have posted a similar question before but this is a slightly
different issue so i thought i'd start afresh.

I am trying to create a chart with a time (eg 01:15.000 [mm:ss.000] )on
the y values, plotted against a time of day. I am not selecting a data
range but adding up to 26 new series (each series has slightly
differing time of day values). However the only way I can get the time
of day x values to display anything other than 00:00:00 is to set the
min and max on the scale to the start and end time of this range eg
15:00 to 16:00.
I know I am doing something wrong if I have to do this but I CANT work
out what! Obviously the data is changeable so the start and end time of
this range will change with different data so I can't input this every
time.


My apologies if this explanation is poor but it has been a long day! I
have been working on this spreadsheet for nearly 13 hours solid and it
is driving me crazy! I am soo frustrated but if I stop in the middle of
doing this i'll have forgotten what I was doing in the morning.

A final thankyou to all of the people on this forum who have made this
sheet possible so far!