Hi Val, I have just had another quick look at the file I prepared.

Cells B 4 to C 8 inclusive of the Chart Worksheet were, by design, set up as
Number format. The Worksheet is designed to work on the 24 hour clock system.

If you therefore change the above cells to read as follows:-

12
13
14
15
16

- in B4 to B8 then:-

13
14
15
16
17

- in C 4 to C 8 thinsg should work correctly.

I think you said in your original posting (I have not checked it so may be
wrong) that you wanted the 24 hour clock on the vertical axis.

Hope the above assists further.

If it does please hit Yes.

Thanks.





"val" wrote:

Thanks for the file. I looked at its formatting to see what you did
differently than I did, but things look the same, although yours has accurate
data points for both series and mine does not. However, when I changed your
numbers to be times, the y axis was no longer accurate, instead, it first
displayed 00:00:00 for all tic marks, but when I finished changing the second
series data, it now just shows the 00:00:00 at the base and top of the axis.

Still, the lines and points are accurate (I can tell by hovering over each
point) :-) I just cannot figure out what you did that I have not done in my
original chart.

"trip_to_tokyo" wrote:

I have just put up a file for you at:-

http://www.pierrefondes.com/

It is item number 53 towards the top of my home page.

If my comments have helped please hit Yes.

Thanks.



"val" wrote:

I am trying to chart two sets of data on one chart. The data sets will come
from sheets within the same spreadsheet.

Both sets use dates, but they might be different dates, so I'd like to have
the x axis show consecutive dates (e.g 1-1-10 through 1-31-10)

The y axis in both cases will be time of day. I want to display time by
hourly increments for 24 hours on this axis.

I want the chart to show times medication is administered (from sheet 1)
and times a specific event occurs (from sheet 2)

I have been trying for hours and getting nowhere. I generally chart using
bars, but did not think this would be so different.

Help, please.

Val