How do I create a timeline chart in Excel?

excel charts timeline
casaout picture casaout · Mar 5, 2014 · Viewed 14.6k times · Source

How do I create a timeline 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 problem is that Excel would combine all the same activities to one item and don't visualize it on the timeline... I also can't do it by hand as I have several 1000 entries to visualize...

I found this post on Stackoverflow, but there there is only one activity per entry and not mulitple times the same...

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.

This is what I imagine the timeline to look like: This is what I imagine the timeline to look like

Answer

casaout picture casaout · Oct 31, 2016

As I didn't find a solution that let me create a timeline in Excel, I used JavaScript and the visualization framework D3, together with a neat opensource library, d3-timeline: https://github.com/jiahuang/d3-timeline

Related questions

How do I create a timeline chart which shows multiple events? Eg. Metallica Band members timeline on wiki

How do I create a timeline chart which shows multiple events? Eg. Metallica Band members timeline on wiki ? where it shows the multiple band members and their durations. Technologies to be used : Microsoft Office primarily. Any exotic technology where the …

Read More
Swap x and y axis without manually swapping values

So I have a set of data that has conditional formatting. Basically it's a set of photometric measurements of stars that I want to put on a chart with different colors for stars in different ranges of Color Index (basically …

Read More
Reordering Chart Data Series

How does one reorder series used to create a chart in Excel? For example, I go to the chart, right click > Select Data. In the left column I see series 1, series 2, to series n. Say, I want to move …

Read More