SyntaxFix

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

A Stacked bar chart should suffice:

Setup data as follows

Name    Start       End         Duration (End - Start)
Fred    1/01/1981   1/06/1985    1612   
Bill    1/07/1985   1/11/2000    5602  
Joe     1/01/1980   1/12/2001    8005  
Jim     1/03/1999   1/01/2000    306
  1. Plot Start and Duration as a stacked bar chart
  2. Set the X-Axis minimum to the desired start date
  3. Set the Fill Colour of thestart range to no fill
  4. Set the Fill of individual bars to suit

(example prepared in Excel 2010)

enter image description here

Examples related to excel

• Python: Pandas pd.read_excel giving ImportError: Install xlrd >= 0.9.0 for Excel support • Converting unix time into date-time via excel • How to increment a letter N times per iteration and store in an array? • 'Microsoft.ACE.OLEDB.16.0' provider is not registered on the local machine. (System.Data) • How to import an Excel file into SQL Server? • Copy filtered data to another sheet using VBA • Better way to find last used row • Could pandas use column as index? • Check if a value is in an array or not with Excel VBA • How to sort dates from Oldest to Newest in Excel?

Examples related to charts

• how to set start value as "0" in chartjs? • Removing legend on charts with chart.js v2 • How to display pie chart data values of each slice in chart.js • How to set ChartJS Y axis title? • In Chart.js set chart title, name of x axis and y axis? • Android charting libraries • Click events on Pie Charts in Chart.js • Swap x and y axis without manually swapping values • How to clear a chart from a canvas so that hover events cannot be triggered? • Remove x-axis label/text in chart.js

Examples related to timeline

• Responsive timeline UI with Bootstrap3 • How do I create a timeline chart which shows multiple events? Eg. Metallica Band members timeline on wiki • How to view file history in Git? • How to create a timeline with LaTeX?