Search results
May 24, 2021 · Stacked bar charts may work for you, but I think each series stack on top of the previous. So it will be difficult to organise your data. Say you have wake, sleep, wake, away, sleep. Those would have to each been in its own column and all would be different colours. You would have to manually set all the wakes/etc to the same colour.
Like the post above, I basically want to make a line graph with dates on the x-axis and time on the y-axis. But I quickly realised it's difficult because the date changes if I go to bed before midnight. Here is a screenshot of the data format I'm collecting:
Sep 27, 2016 · EDIT. Insert new column called RoundedTime; You can round-off the Time to nearest 12 Hour using =MROUND(D2,"12:00") formula; and then create Line chart using Date, RoundedTime, Height fields. Click Line in the chart and choose Format button in the chart as highlighted and in the bottom, choose smooth line. Now, you will get smooth line chart as ...
Apr 8, 2009 · The formula is a simple if, then, else formula. If your time is<.5 (or before noon) it adds 1 + your time. Otherwise, it gives the same result as the date entered. For 3 AM, the result would be 1.125. For 9 PM, the result would be .875. (The .5 / noon time could be changed to reflect your actual sleep habits.)
Mar 31, 2012 · If you were asleep before midnight, put midnight (i.e., 1) for end of the last sleep period of the first day and midnight (i.e., 0) for the start of the first sleep period of the second day. Make another table with the same number of rows and columns. This will have formulas pointing to the first table, but it will show durations.
Mar 8, 2017 · To properly chart this, you'll need a "helper column" that translates times to essentially before or after midnight-giving them the correct relation to midnight. So, in your helper column, add 1 (day) to times before noon, and add 0 (days) to times afternoon. =IF(sleep_time < 0.5, sleep_time+1,sleep_time)
People also ask
How do you chart a time in Excel?
How to make a smooth line chart in Excel?
How to create a line chart in Excel?
Is there a super lame way to report sleep time?
How do I add a day to a time in Excel?
How do I create a scatter chart with a date and time?
Aug 20, 2020 · 2. Restful Sleep - record in hours and minutes, so for example 5hr 44 mins. 3. Restless Sleep - record in hours and minutes, so for example 1hr 39 mins. 4. Restful Sleep - 78%. I am mindful of the fact that there are 60 minutes in an hour compared to say a standard 100 units/per cent when it comes to numbers. I would like to have a graph which ...
