Create an Excel Timeline Chart from Start and End Years
Question details
Create a timeline chart showing a start-to-end year bar for each name.

- 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.
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.
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.
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.
Select the Name, Start Year, and Duration columns, including their headers. Go to Insert > Bar Chart and choose Stacked Bar.
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.
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.
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 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. 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. Create a stacked bar: Select the Name, Start Year, and Duration columns, then choose Insert > Chart and select a stacked bar chart.
- 3. Hide the start-year series: Select the Start Year bars, open Format Data Series, and set the fill and border to none.
- 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.

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.




