title: How do I create a timeline chart in Excel?
body: <p>How do I create a <strong>timeline</strong> chat which visualizes peoples activities throughout a day in one graph? On the x-axis I plan to place the time. And the y-Axis would be the different persons. First, I thought of a simple stacked bar chart. However, the <strong>problem is that Excel would combine all the same activities to one item</strong> and don't visualize it on the timeline... I also can't do it by hand as I have several 1000 entries to visualize... </p>
  
  <p>I found <a href="https://stackoverflow.com/questions/12870686/how-do-i-create-a-timeline-chart-which-shows-multiple-events-eg-metallica-band">this</a> post on Stackoverflow, but there there is only one activity per entry and not mulitple times the same...</p>
  
  <p>It would be great if I could use Excel (as my data set is there). But if there is a better way (i.e. tool) I'd also appreciate new suggestions.</p>
  
  <p>This is what I imagine the timeline to look like:
  <img src="https://i.stack.imgur.com/HIIx0.png" alt="This is what I imagine the timeline to look like"></p>