Closed Thread
Results 1 to 2 of 2

Plotting Day and Time on a Graph

  1. #1
    Registered User
    Join Date
    11-17-2015
    Location
    Chester, England
    MS-Off Ver
    2007
    Posts
    5

    Plotting Day and Time on a Graph

    I have a load of data for the time appointments have been booked on different days (over several weeks). I want to be able to see if there are any patterns in the data, to look for busiest time periods.

    I was wondering if there was a way to group the appointment times into hourly blocks and plat that against day of the week. If not, some kind of scatter graph may work but I am struggling to figure it out. I have also got data for two branches and was hoping to be able to compare the two rather than just look at it as a whole.

    I have attached some sample data.

    Thanks a million in advance for any help you can offer.
    Attached Files Attached Files

  2. #2
    Banned User!
    Join Date
    06-08-2012
    Location
    Left the forum!
    MS-Off Ver
    Left the forum!
    Posts
    5,187

    Re: Plotting Day and Time on a Graph

    Deleted reply

    Duplicate of thread https://www.excelforum.com/excel-cha...sing-data.html

    As per forum rules, please only start one thread per issue. I have asked for this one to be locked.
    Last edited by jason.b75; 08-16-2019 at 05:10 AM.

Closed Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1