+ Reply to Thread
Results 1 to 2 of 2

Bar graph with events happening throughout the day.

  1. #1
    Registered User
    Join Date
    04-03-2019
    Location
    Tartu, Estonia
    MS-Off Ver
    Microsoft Office 365 ProPlus
    Posts
    1

    Bar graph with events happening throughout the day.

    Hello there!

    I'll try to explain this as well as I can.
    I have two types of events, and each event has its start and end time. For example (red 10.15-11.07; blue 11.55-12.30; blue 15.33-17.22; etc)
    What I need is a type of bar graph, where the whole bar would be 24h long (left end is 00.00, right end is 23.59), and these events would be colorized on this bar.
    Then there should be different bars on top of each other, representing different days.

    How could this be done? I found something similar that I looked for, but it was restricted to one event per day.
    I can't post here, but if anyone wants I can send a drawing of what I want the chart to look like.

    So, if anybody knows how to approach this or how is the most efficient way to lay out the data, I'll be thankful.

  2. #2
    Forum Guru
    Join Date
    08-28-2014
    Location
    USA
    MS-Off Ver
    Excel 2019
    Posts
    17,532

    Re: Bar graph with events happening throughout the day.

    Hello merekala and Welcome to Excel Forum.
    This proposal is based on a solution given by 'pnuts' on another forum.
    It is usually recommended that data be arranged in record form as modeled in columns A:D.
    To get the correct values for the chart only the start time is used and then the durations of the events and times between events as modeled in G2:L2
    Formulas in these cells are similar to =D2-C2; =C3-D2 etc.
    Select F1:L2 and insert a stacked bar chart. Select chart tools > design > switch row/column.
    From here you'll need to individually select the fill color of the different parts of the bar. I chose to fill all the times between events white and then the others based on the event name.
    Let us know if you have any questions.
    Attached Files Attached Files
    Consider taking the time to add to the reputation of everybody that has taken the time to respond to your query.

+ 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. Creating a graph of cumulative events over time
    By eckliptic in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 02-05-2015, 04:05 PM
  2. Replies: 14
    Last Post: 01-21-2015, 04:53 PM
  3. Help creating a chartof events happening over time
    By Urbano in forum Excel General
    Replies: 0
    Last Post: 07-06-2014, 10:54 PM
  4. Creating a graph in Excel to track scores and events along the way....
    By brendan344 in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 04-01-2013, 01:54 PM
  5. What kind of graph is used to show events over time
    By darbid in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 07-28-2009, 08:53 AM
  6. How to get graph data using Chart Events?
    By cricrazy in forum Excel Charting & Pivots
    Replies: 6
    Last Post: 01-24-2009, 06:43 PM
  7. Displaying graph and charts on events
    By soteman in forum Excel General
    Replies: 0
    Last Post: 07-10-2006, 03:19 PM

Tags for this Thread

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