SyntaxFix

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

As mentioned in the earlier comment, stacked bar chart does the trick, though the data needs to be setup differently.(See image below)

Duration column = End - Start

  1. Once done, plot your stacked bar chart using the entire data.
  2. Mark start and end range to no fill.
  3. Right click on the X Axis and change Axis options manually. (This did cause me some issues, till I realized I couldn't manipulate them to enter dates, :) yeah I am newbie, excel masters! :))

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?