Thread: Plotting time vs. day of the week

I have dates in a column and the amount of time in a room in another column can some one tell me how to get this into a graph. vertical axis will be the median time in the room and the horizontal axis will be the day of the week,(monday, tuesday etc).

Welcome to the forum.

=text(a1, "dddd")

Post an example and explain in context.

Umm -- how about an example workbook

Code:

       ----A---- ---B---- C ---D--- ----E---- --F---
   1   PROCDATE  ROOMTIME   Weekday    Day    Median
   2   Tuesday       0:59      1    Sunday     0:57 
   3   Tuesday       0:55      2    Monday     1:35 
   4   Saturday      1:14      3    Tuesday    0:57 
   5   Friday        0:43      4    Wednesday  0:50 
   6   Wednesday     0:26      5    Thursday   0:52 
   7   Thursday      2:58      6    Friday     1:01 
   8   Sunday        0:57      7    Saturday   1:14 
   9   Monday        1:41                           
  10   Friday        1:00                           
  11   Sunday        0:34                           
  12   Wednesday     0:50                           
  13   Thursday      0:52                           
  14   Monday        1:29                           
  15   Wednesday     0:52                           
  16   Friday        2:07                           
  17   Friday        1:01                           
  18   Friday        1:12                           
  19   Sunday        1:29                           
  20   Thursday      0:42

The array formula in F2 and copied down is =MEDIAN(IF(WEEKDAY($A$2:$A$20)=D2, $B$2:$B$20))

It MUST be confirmed with Ctrl+Shift+Enter, not Enter

You're welcome. Would you please mark the thread as Solved?