Timeline Chart in Google Sheets: Create and Customize One

To make a timeline in Google Sheets, use Insert > Timeline if you want an interactive date-based view, or create a stacked bar chart with a hidden start-date offset if you need a conventional chart. The first option is usually quicker; the stacked-bar method gives you more control over a chart you can place in a report or dashboard.

What a timeline chart means in Google Sheets

People use “timeline chart” to mean two different things in Sheets. Google Sheets offers a Timeline view for viewing records across dates. It also lets you make a familiar project timeline from a stacked bar chart, where each task is a bar: one series positions the bar at its start date, and another shows its duration.

These approaches are not interchangeable in every situation. Timeline view is designed to help you explore and group dated records. A stacked bar chart is a chart object that works well in a presentation, printed report, or dashboard. It takes a little data preparation because the start-position series must be visually concealed.

A timeline is most useful when a row represents an event, task, or period and the dates have a clear meaning. It can show a product launch plan, a class schedule, a maintenance calendar, or a list of customer milestones. It is less suitable for showing how a value changes continuously over time; for that, a line chart is usually a better fit.

Choose between Timeline view and a stacked bar chart

Start by deciding what readers need to do with the information. If they need to scan and filter a set of dated records, try Timeline view. If they need a static visual with an axis and bars, build a stacked bar chart. A chart is also useful if the sheet’s audience needs a visual they can copy into a document or place alongside other charts.

Choose Timeline view for interactive exploration of records, such as viewing project tasks by date or grouping events by team.
Choose a stacked bar chart for a presentation-ready overview in which tasks appear as horizontal bars across a shared scale.
Choose a calendar or project-management tool if you need features such as assigning work, tracking dependencies, or notifying people about schedule changes.

Timeline view is a feature of Google Sheets, not simply another name for a stacked bar chart. If you do not see it under Insert, the feature may not be available for your account or current setup. Check that you are working in Google Sheets, that your data includes properly formatted dates, and that the feature is available to your account.

Prepare the data before creating a chart

For a basic task timeline, organize the source data with one task per row and separate columns for the task name, start date, and finish date. Use genuine date values, not text that only looks like a date. In a blank cell, a date may be displayed differently depending on its number format, but Sheets needs to recognize it as a date to calculate a reliable duration.

For example, imagine the source table uses A1:C4, with headers in row 1: Task in column A, Start in column B, and Finish in column C. The three tasks start on April 1, April 4, and April 8, and finish on April 5, April 10, and April 12, respectively. Use dates from the same year in the actual sheet. Add two helper columns for the chart: Offset, the number of days from the earliest start, and Duration, the elapsed days between start and finish.

With task start dates in B2:B4, enter this in D2 to calculate each task’s offset from the earliest start date:

=B2-MIN($B$2:$B$4)

With start dates in B2:B4 and finish dates in C2:C4, enter this in E2 to calculate elapsed duration in days:

=C2-B2

Fill both formulas down through row 4. The example produces offsets of 0, 3, and 7 days, and durations of 4, 6, and 4 days. These results count the elapsed time between the two dates: April 1 to April 5 is four days. If your schedule treats both the start and finish dates as full working calendar days, use this duration formula in E2 instead:

=C2-B2+1

That inclusive convention produces durations of 5, 7, and 5 days for the example. Choose one convention and apply it consistently; otherwise, bars may appear a day shorter or longer than readers expect. If the schedule uses working days rather than calendar days, this simple subtraction also includes weekends and holidays, so it will not represent working time accurately.

Create a stacked bar timeline chart

Make a small chart-source block containing three columns: Task, Offset, and Duration. For instance, put those headers in G1:I1, then copy the task names and helper values into G2:I4. Keeping this block together makes it easier to select the chart data than selecting separated columns from the source table.

Select the chart-source range, such as G1:I4.
Choose Insert > Chart. Sheets opens the Chart editor, usually in a panel on the right.
In the editor’s Setup tab, open Chart type and choose Stacked bar chart. Check that Task is used as the category labels and Offset and Duration are the two series.
Open the Customize tab and adjust the series colors so the Offset series blends into the chart’s plot-area background. For a white chart, a white offset series will usually disappear against the plot area. Remove or clarify its legend entry so readers do not mistake it for a task duration.
Add a useful chart title, such as “Project schedule” or “Launch tasks,” and resize or move the chart as needed.

The Offset series must remain in the chart data even though you hide its appearance: it pushes each visible Duration bar to the correct position along the horizontal scale. If you delete that series, every task bar starts at zero and the chart no longer represents the task start dates. Keep the plot background and hidden-series color matched; a different background color can reveal the offset bars.

Use Google Sheets Timeline view

For an interactive date view, arrange the source table with clear column headers and a row for each event or task. Select the data, then choose Insert > Timeline. In the setup panel, assign the columns Sheets should use for the card title and date information. Depending on the data and the options available in your account, you can also use fields such as an end date, card details, grouping, or color to make the view easier to read.

Use a concise title field so cards are recognizable without opening them. A task name such as “Approve packaging” is more useful on a timeline than a long project description. Keep extra notes in a detail field if the view offers one. If tasks have both start and finish dates, assign the appropriate date columns rather than treating the finish date as a separate event.

Timeline view is linked to the underlying sheet data, so changes to the source records can be reflected in the view. It is not a substitute for checking the source table: inconsistent dates, blank task names, or misassigned fields can still make the timeline confusing. If the option is missing or the view cannot interpret a date, verify the date values and consult Google’s current Sheets feature information for account availability.

Make dates and labels easy to understand

A chart can be mathematically correct and still be hard to interpret. In the stacked-bar method, the horizontal scale is based on offsets from the earliest start date, so its values represent elapsed days from that baseline—not automatically recognizable calendar dates. Add context in the chart title or axis title, such as “Days after April 1,” and state the actual baseline date where readers will see it. Do not label the axis as calendar dates unless the displayed scale really uses calendar dates.

Use task labels that remain readable at the chart’s final size. Long labels can crowd a chart, especially when the task list is large. Consider shortening labels for display while keeping fuller descriptions in the source table. Order the source rows in a way that helps readers scan the work, such as by start date, phase, or team. If the chart’s task order is not what you want, try arranging the source rows accordingly before relying on chart-axis settings.

Use color to communicate a real distinction, such as project phase or team, rather than giving every task an unrelated color. In a basic stacked chart, the Duration series has one color for all tasks. To distinguish task groups, you may need separate duration series or a different chart design, which adds complexity. Always preserve enough contrast between the duration bars and the chart background.

Common problems and how to fix them

The bars all start at zero. Confirm that Offset is included as the first series in a stacked bar chart. Hiding its color is not the same as removing it.
The timeline shows strange durations. Check that start and finish cells are recognized as dates, that the finish is not earlier than the start, and that the formula uses the intended inclusive or elapsed-day convention.
Dates appear as large numbers. Spreadsheet dates are stored as serial values. In the source table, apply a date format using Format > Number. For a relative-offset chart, remember that the chart scale is elapsed days from a baseline, not a date-formatted source column.
Some tasks have no visible bar. Look for blank dates, zero-length durations, or a chart range that omits rows. A same-day task may need an inclusive duration calculation or a separate marker-style design to be visible.
The hidden series shows through. Match its color to the plot-area background and check that the chart background has not changed. If the chart will use a colored background, update the hidden series color too.
The chart updates incorrectly after adding tasks. Confirm that the chart’s data range includes the new rows. If the range is fixed, extend it in the Chart editor’s Setup tab or use a source range that includes the rows you expect to add.

A frequent misconception is that a date axis will appear automatically just because the source table contains dates. In the stacked-bar technique, the chart uses numeric offsets and durations. The axis therefore needs an explanatory label or another design choice; adding start-date values as enormous offsets is not a safe shortcut, because it can make the visible bars compress against a much larger scale.

Alternatives, collaboration, and limits

A spreadsheet timeline is a good choice for a small or medium schedule that is already maintained in rows and columns. It is easy to share through Google Sheets collaboration and can be adapted as the data changes. Timeline view suits browsing records, while the stacked chart suits a compact visual summary. Neither automatically turns a list of tasks into a full project plan with dependency logic.

For complex schedules, consider whether a dedicated project-management tool is a better fit. Such tools may offer dependency links, workload views, reminders, or permission controls beyond a chart. You can still export or summarize project data in Sheets, but maintain a clear source of truth so edits in multiple places do not create conflicting schedules.

Google Sheets runs in a web browser, and its menus and sharing model differ from Microsoft Excel. Excel has its own chart and project-planning options; the Google Sheets menu paths in these instructions do not apply to Excel. A Google account can use Sheets without buying a separate spreadsheet application, but organizational access, storage, and other Workspace services depend on the account and its plan. Check the current terms for your account rather than assuming every feature is included.

Frequently Asked Questions

Does Google Sheets have a built-in timeline chart?
Google Sheets has a Timeline view that you can access through Insert > Timeline when it is available to your account. For a conventional bar chart, users commonly create a stacked bar chart with an offset and duration series.

How do I show task start and end dates in Google Sheets?
For Timeline view, assign the start and end date columns in its setup options when those fields are available. For a stacked bar chart, calculate an offset from the earliest start date and a duration from each task’s start and finish.

Can I make a timeline chart in Google Sheets for free?
Google Sheets is available with Google accounts, but feature availability and organizational access can vary. Check the account you are using and its current Google Workspace terms if Timeline view or another feature is not available.

Why does my timeline chart show numbers instead of dates?
The stacked-bar method charts elapsed-day offsets as numbers, not calendar-date labels. Explain the baseline date in the chart title or axis title. Timeline view is often a better choice when you want an interactive display organized around actual dates.

Can Google Sheets make a Gantt chart?
Yes. A basic Gantt-style chart can be made with a stacked bar chart: hide the start offset series and show the duration series. It can display task timing, but it does not automatically provide dependencies or other advanced project-management functions.

Try it: the Percentage Formula Generator: percent of, percent change, increase and decrease, with the formula.

More in Charts & pivot tables

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.