+ Reply to Thread
Results 1 to 4 of 4

Showing busy hour by month

  1. #1
    Registered User
    Join Date
    10-18-2011
    Location
    Australia
    MS-Off Ver
    Excel 2007
    Posts
    5

    Showing busy hour by month

    Hi All,

    I got stucked how to present the following information in a chart.

    Here is my table structure Month, Time, Number of Surge(Surge is the busy hour when we high case volume).
    Explaination of data table : During April-21 at 3:00 am there is 1 occurrence of Surge. April-21 at 13:00 there is 24 occurrences of Surge

    My goal is to show Month in X axis and Time in Yaxis and values are from Surge column. Please let me know if any got any thoughts.

    Month Time Number of Surge Occurences
    Apr-21 0:00:00 7
    Apr-21 2:00:00 1
    Apr-21 3:00:00 2
    Apr-21 4:00:00 1
    Apr-21 5:00:00 1
    Apr-21 8:00:00 1
    Apr-21 9:00:00 6
    Apr-21 10:00:00 9
    Apr-21 11:00:00 20
    Apr-21 12:00:00 21
    Apr-21 13:00:00 24
    Apr-21 14:00:00 17
    Apr-21 15:00:00 26
    Apr-21 16:00:00 29
    Apr-21 17:00:00 30
    Apr-21 18:00:00 19
    Apr-21 19:00:00 12
    Apr-21 20:00:00 20
    Apr-21 21:00:00 20
    Apr-21 22:00:00 6
    Apr-21 23:00:00 9
    May-21 0:00:00 2
    May-21 11:00:00 1
    May-21 12:00:00 3
    May-21 13:00:00 5
    May-21 14:00:00 2
    May-21 15:00:00 8
    May-21 16:00:00 1
    May-21 17:00:00 4
    May-21 18:00:00 3
    May-21 19:00:00 1
    May-21 20:00:00 2
    May-21 22:00:00 1
    May-21 23:00:00 2

  2. #2
    Forum Expert Crooza's Avatar
    Join Date
    10-19-2013
    Location
    Hunter Valley, Australia
    MS-Off Ver
    Excel 2003 /7/10
    Posts
    2,082

    Re: Showing busy hour by month

    I recreated a dummy for you to look at. Not all the data aligns with yours but you'll get the drift. This is an XY chart with two data sources. It doesn't exacly give yo what you want as I have no idea how you'd put the month on the x axis and time on the y axis and still chart the number of surges. I think this might suffice though.
    Attached Files Attached Files
    Happy with my advice? Click on the * reputation button below

  3. #3
    Registered User
    Join Date
    06-17-2020
    Location
    Bangkok, Thailand
    MS-Off Ver
    365
    Posts
    17

    Re: Showing busy hour by month

    My idea using Horizontal Lollipop chart (actually scatter chart with error bar).
    Attached Images Attached Images

  4. #4
    Registered User
    Join Date
    10-18-2011
    Location
    Australia
    MS-Off Ver
    Excel 2007
    Posts
    5

    Re: Showing busy hour by month

    Thanks you both, I will give it a try on both and present it here.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 2
    Last Post: 12-24-2015, 03:00 PM
  2. [SOLVED] Column chart showing activity over 24 hour period
    By zoobaby in forum Excel Charting & Pivots
    Replies: 6
    Last Post: 03-16-2013, 07:48 AM
  3. Data Validation Lists & showing Month over Month performance
    By hilpup24 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 12-22-2012, 11:32 AM
  4. Timeline (Gantt) chart showing both hour and date
    By S K ROY in forum Excel Charting & Pivots
    Replies: 6
    Last Post: 11-30-2011, 06:33 PM
  5. Day of the month (1-31) using VBA together with Hour(Now())
    By prefix in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 11-18-2010, 04:33 AM
  6. Replies: 5
    Last Post: 01-09-2009, 10:11 AM
  7. Extract the hour from a cell showing the date and time
    By Paul Sexton in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 02-27-2006, 02:20 PM

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