Chart & Visualization Issues

Create an Excel Timeline Chart from Start and End Years

Camila MilosovichCamila Milosovich Nov 18, 2026 869 views

Question details

Create a timeline chart showing a start-to-end year bar for each name.

Create an Excel Timeline Chart from Start and End Years
Product
Microsoft Excel
Device & OS
not provided
Scenario
The worksheet contains names, start years, and end years that need to be displayed as horizontal intervals.
Observed behavior
Each name should have a bar beginning at its start year and ending at its end year.
Before you start

Arrange the data in columns for Name, Start Year, and End Year, and check that the years are numeric and each end year is at least as large as its start year.

Solution 1Recommended

Build a timeline with an Excel stacked bar chart

Use a hidden start-year series to position each visible duration bar on the year axis.

1
Calculate durations

Add a Duration column. If Start Year is in B2 and End Year is in C2, enter =C2-B2 in D2 and fill the formula down.

2
Insert the chart

Select the Name, Start Year, and Duration columns, including their headers. Go to Insert > Bar Chart and choose Stacked Bar.

3
Hide the offset

Click the Start Year series in the chart, open Format Data Series, and set its fill to No Fill and its border or line to No Line.

4
Adjust the year axis

Right-click the horizontal axis and choose Format Axis. Set suitable minimum and maximum bounds around your data and use whole-number labels so the axis reads as years.

5
Arrange the names

If the names appear in the wrong order, right-click the vertical category axis, choose Format Axis, and select Categories in reverse order.

Build a timeline with an Excel stacked bar chart
Intervals with the same start and end year: The formula End Year minus Start Year produces a zero-length bar when the years match. If you want to count each listed year as a full year, use End Year minus Start Year plus 1; the bar will then end one axis unit after the stated end year.
Create timelines in WPS Spreadsheets

Build a year-based timeline in WPS Spreadsheets

Use a stacked bar chart in WPS Spreadsheets to position duration bars by start year, then hide the offset series and adjust the year axis.

  1. 1. Prepare the data: Open your workbook in WPS Spreadsheets and add a Duration column. Enter =C2-B2 for start and end years in columns B and C, then fill down.
  2. 2. Create a stacked bar: Select the Name, Start Year, and Duration columns, then choose Insert > Chart and select a stacked bar chart.
  3. 3. Hide the start-year series: Select the Start Year bars, open Format Data Series, and set the fill and border to none.
  4. 4. Format the axes: Open Format Axis for the horizontal axis and set year bounds that fit your data. Reverse the category order on the vertical axis if needed.
Show each name's start-to-end interval as a horizontal barOpen and edit Microsoft Excel XLSX and XLS filesUse formulas to calculate durations automaticallyWork with familiar spreadsheet and chart tools
microsoft office alternative - wps office

Frequently Asked Questions

Why should I use a stacked bar chart instead of a histogram?

A stacked bar chart can use the start year as an offset and the duration as the visible bar. A histogram groups numeric values into ranges rather than showing a separate start-to-end interval for each name.

Why does my timeline start at zero?

The horizontal axis may use an automatic minimum of zero. Right-click the axis, select Format Axis, and set the minimum bound to a year at or before your earliest start year.

How do I put the first name at the top of the chart?

Right-click the vertical category axis, open Format Axis, and select Categories in reverse order.

Why is there no visible bar when the start and end years match?

Subtracting the start year from the end year gives a duration of zero. To display a full-year span for each listed year, add 1 to the duration formula, noting that the bar will end one axis unit after the stated end year.