comparison line graph help needed

[val]

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

 

[Bernard Liengme]

You are going to find it much simpler if you get all the data into one place
Let's say Sheet3 is empty
On Sheet3 use formulas of the type =Sheet1!A1 to gather the data from Sheet1
and Sheet2
Make you chart on this sheet until satisfied
Now Cut and Paste the chart to wherever it is needed
best wishes

 

[trip_to_tokyo]

Can the Times Medication Administered and Times Specific Event Occurs be on
the same Worsheet? It makes it easier if you answer yes!

 

[trip_to_tokyo]

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]

I have tried moving the data I want to graph to another sheet, for example:

Date Meds Event
1/5/10 8:35pm
1/6/10 3:00pm
1/7/10 9:00am
1/8/10
1/9/10 6:00 PM
1/10/10 8:05pm
1/11/10
1/12/10 11:35am
1/13/10 3:30 PM
1/14/10
1/15/10
1/16/10 5:15pm
1/17/10 4:32pm 10:45:00 AM, 1:00pm
1/18/10
1/19/10 4:55pm, 9:50 pm 4:45 PM

However, even after I make a chart from this data, I have to manipulate the
series functions in order to show time on the y axis and dates on the x axis.

I am still getting a flat line for the meds data, although I do get
accurately placed event points on the chart.

the time increments are causing me grief also. I want to show time in hourly
increments (military time format) , however although I have tried
manipulating the axis scale in many different ways, I still get odd times
(2:48. 4:24, 7:12, 9:36. 12:00 etc.)

I have been working on this for hours today and will keep on until I get it
correct, Then I'm making a help sheet so I never have to go through this
again. Thanks in advance for your help - I really, really appreciate it!
Val

 

[trip_to_tokyo]

Val, all of your points seem to have been addressed by the chart I have put
up.

 

[val]

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]

I will see if I can spend some time on it Mon Feb 1st to see if I can improve
it.

 

[trip_to_tokyo]

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.