If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
comparison line graph help needed
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 |
#2
|
|||
|
|||
comparison line graph help needed
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 -- Bernard Liengme Microsoft Excel MVP http://people.stfx.ca/bliengme "val" wrote in message ... 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 |
#3
|
|||
|
|||
comparison line graph help needed
Can the Times Medication Administered and Times Specific Event Occurs be on
the same Worsheet? It makes it easier if you answer yes! "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 |
#4
|
|||
|
|||
comparison line graph help needed
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 |
#5
|
|||
|
|||
comparison line graph help needed
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 "Bernard Liengme" wrote: 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 -- Bernard Liengme Microsoft Excel MVP http://people.stfx.ca/bliengme "val" wrote in message ... 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 . |
#6
|
|||
|
|||
comparison line graph help needed
Val, all of your points seem to have been addressed by the chart I have put
up. "val" wrote: 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 "Bernard Liengme" wrote: 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 -- Bernard Liengme Microsoft Excel MVP http://people.stfx.ca/bliengme "val" wrote in message ... 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 . |
#7
|
|||
|
|||
comparison line graph help needed
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 |
#8
|
|||
|
|||
comparison line graph help needed
I will see if I can spend some time on it Mon Feb 1st to see if I can improve
it. "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 |
#9
|
|||
|
|||
comparison line graph help needed
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 |
Thread Tools | |
Display Modes | |
|
|