0
0
Google Sheetsspreadsheet~8 mins

Timeline charts in Google Sheets - Dashboard Guide

Choose your learning style9 modes available
LearnWhyDeepSheetTryChallengeScenarioRecallDash
Dashboard Mode - Timeline charts
Dashboard Goal

Track project tasks over time to see when each task starts and ends. This helps manage deadlines and workload.

Sample Data
TaskStart DateEnd DateDuration (days)
Design2024-06-012024-06-05=C2-B2+1
Development2024-06-062024-06-15=C3-B3+1
Testing2024-06-162024-06-20=C4-B4+1
Deployment2024-06-212024-06-22=C5-B5+1
Review2024-06-232024-06-25=C6-B6+1
Dashboard Components
  • KPI Card: Total Project Duration
    Formula: =MAX(C2:C6)-MIN(B2:B6)+1
    Shows total days from first start to last end date.
  • Timeline Chart: Gantt-style bar chart showing tasks over dates.
    Uses stacked bar chart with:
    - Start offset: =B2 - MIN(B$2:B$6)
    - Duration: =C2 - B2 + 1
    Chart data range includes Task names, Start offset, and Duration columns.
    This visually shows when each task happens on the timeline.
  • Task Table: Shows Task, Start Date, End Date, Duration columns for detail.
Dashboard Layout
+----------------------+-----------------------+
| Total Project Days    | Timeline Chart        |
| (KPI Card)           | (Gantt Bar Chart)     |
+----------------------+-----------------------+
| Task Table (Details)                          |
+----------------------------------------------+
Interactivity

Add a date filter to select a range of dates. When you pick a start and end date:

  • The timeline chart updates to show only tasks overlapping that date range.
  • The task table filters to show only tasks active in that range.
  • The total project days KPI updates to show duration within the filtered range.

This helps focus on specific project periods.

Self Check

If you add a filter to show only tasks starting on or after 2024-06-10, which components update?

  • The timeline chart will hide tasks starting before 2024-06-10.
  • The task table will list only tasks starting on or after 2024-06-10.
  • The total project days KPI will recalculate based on filtered tasks.
Key Result
A project timeline dashboard showing task durations as a timeline chart, total project days, and task details.