With Spreadsheet.com, you can quickly create interactive Gantt charts side-by-side with your spreadsheet data to visualize work schedules and relationships between tasks.
Gantt views add an interactive timeline to the right of your worksheet showing taskbars corresponding to each row in the table region. For example, in a Tasks worksheet, you can use a Gantt view to manage a project’s schedule and create task dependencies.
Topics in this article
- Creating Gantt views
- Gantt Chart Features
- Adjusting your Gantt Chart
- Project Management Settings
Creating Gantt views
Gantt views can be created in any worksheet by clicking “+ New view” in the view selector dialog and choosing Gantt, or selecting "Create new Gantt view" from the View menu.
When the first Gantt view is created in a worksheet, Spreadsheet.com will guide you through enabling Project Management on that worksheet. Here you can configure which columns are used for task management, settings for working days and hours, and whether or not to enable task dependencies:
Gantt Chart Features
Expanding Tasks and Dragging Tasks
Each taskbar in the Gantt chart corresponds to a row in your project plan and can be edited either in the worksheet or directly from the Gantt chart. Double-clicking on a taskbar expands it, just like expanding the row. Similarly, you can drag and drop taskbars to adjust their timing and duration.
When you drag and drop taskbars in the Hours view, they will snap to the nearest hour.
Taskbars in the Gantt chart can indicate the % complete for a given row as a function of days remaining and project status. For instance, in the project plan below, we can see that our "Product Use Case Definition" is 100% complete, so the entire taskbar is shaded green (matching our status color), while the "Marketing Plan" is only 26.2% shaded because it's only 26.2% complete.
Rows in hierarchies calculate their completeness as a percentage of child cells and the days remaining.
Dependencies allow you to track tasks that must start after another task has finished. Dependencies can be established between tasks by dragging connections between taskbar antennae, as shown here:
Note how the new dependency is reflected in column "K - Predecessor."
Setting a task's duration to 0 days will create a "milestone" notated as a diamond in your Gantt chart. Milestones are often used in projects as critical, intermediate check-points, moments when you assess progress, and the project plan overall.
Adjusting your Gantt Chart
A Gantt toolbar above the chart provides quick ways to zoom in and out of the chart, along with additional features such as bar labels, and highlighting the critical path:
Taskbars can be moved and resized using the mouse, via the zoom level in the Gantt toolbar, the zoom in and zoom out options in the toolbar, and can be widened or narrowed with the Gantt slider.
Project Management Settings
You can return to and modify the project management settings of a Gantt chart in the project management menu.
From the Project Management menu, you can adjust which columns are used for a task's start date, end date, user, duration, status, and more. You can also account for days off, start times, and set up dependencies between tasks.
Note: Columns selected for project management must retain the data type needed for project management. For instance, you cannot change an end date column to the text data type.