Hello,
I am wondering if someone can help me plot a graph of i.e. time i go to bed. I have no problems plotting any other values and adding trend lines etc. But, with time, it is much harder as excel doesnt seem to respond appropriately to the day change.
I tried to plot it myself - here is my sample data, and my attempt to plot it
http://cid-bf7398e8f9f92dc5.skydrive.live.com/self.aspx/Public/timegoingtobed.xlsx
As you can see, even though the time series are i.e. 1am, 12:30 am, 11:30 PM, 1,am, 1am, there is a HUGE dip in the graph.
Can anyone advise what am I doing wrong, or is this just a flaw in excel
thanks in advance
sasha
I am wondering if someone can help me plot a graph of i.e. time i go to bed. I have no problems plotting any other values and adding trend lines etc. But, with time, it is much harder as excel doesnt seem to respond appropriately to the day change.
I tried to plot it myself - here is my sample data, and my attempt to plot it
http://cid-bf7398e8f9f92dc5.skydrive.live.com/self.aspx/Public/timegoingtobed.xlsx
As you can see, even though the time series are i.e. 1am, 12:30 am, 11:30 PM, 1,am, 1am, there is a HUGE dip in the graph.
Can anyone advise what am I doing wrong, or is this just a flaw in excel
thanks in advance
sasha