Results 1 to 5 of 5
  1. #1
    3 Star Lounger
    Join Date
    Aug 2001
    Location
    Seattle, Washington
    Posts
    251
    Thanks
    29
    Thanked 2 Times in 2 Posts

    Day of the week scatter chart

    I have a worksheet that shows my glucose readings for a period. In addition to the data, I want to show the day of the week, to make sure I did the data entry today. I can also have more than one reading for a particular day.

    I would now like to make a scatter chart that shows my doctor what my readings are for a particular day, aggregating all the readings for that same day, for all the days in the data. In my scatter chart, I want to start with Sunday. This may not be feasible, because of sorting problems.

    I might have twenty entries for each day, over a period of one hundred forty days. What were my readings for Mondays, Tuesdays, etc?
    In my enclosure, you can see I use a format of ddd to convert the date numeric entry to an alpha entry day. 5/22/2014 becomes Thursday.

    Iím almost certain the solution lies in the day of the week cells.
    Attached Files Attached Files
    Bob Wall

  2. #2
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts
    Not exactly sure what you are after, but if you change your formula in O12 to
    =G12+H12
    you will have both day and time together. You can format it
    ddd mm/d hh:mm
    to display day of week, month, day and time.

    Then your chart will display based on day/time and you can autoscale the min/max and format to something like:
    ddd mm/d
    to display the day of the week, month and day of month for X-Axis.

    If you want to expand on a particular day you can set those days in the min/max (you will have to use the serial date) or you could filter the data and the chart will display only the filtered data.

    Steve

  3. The Following User Says Thank You to sdckapr For This Useful Post:

    BobWallToo (2014-06-11)

  4. #3
    New Lounger
    Join Date
    Dec 2013
    Posts
    22
    Thanks
    2
    Thanked 6 Times in 6 Posts
    If you change column F to use the Weekday function, then you can sort the database on col. F and all the Sundays will be followed by all Mondays, etc.

    For example, F12 would be =WEEKDAY(G12). The result is a number 1 through 7, where 1 = Sunday.

    Interestingly, you can leave your formatting the same, dddd, and the displayed result will be the same as it is now, the spelled out date of the week.

  5. The Following User Says Thank You to THill For This Useful Post:

    BobWallToo (2014-06-11)

  6. #4
    3 Star Lounger
    Join Date
    Aug 2001
    Location
    Seattle, Washington
    Posts
    251
    Thanks
    29
    Thanked 2 Times in 2 Posts
    Excellent suggestion.. I've never used the =weekday function before.

    Bob Wall

  7. #5
    New Lounger
    Join Date
    Dec 2013
    Posts
    22
    Thanks
    2
    Thanked 6 Times in 6 Posts
    Thanks for the wave—it made my day!

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •