Spreadsheet

The spreadsheet displays information about bars, tasks and allocations in the bar chart. A typical spreadsheet might display the Name, Start, Finish and Duration columns.

You can add and remove columns and change the information that is displayed in each column. You can also edit bars and tasks by typing in the spreadsheet. For example, you can enter bar and task names and specify start and finish dates by typing in the appropriate columns on the spreadsheet.

You can save the current spreadsheet as a table so that it can be applied to other bar chart views. For example, you might have one table that you use for entering new tasks and another for assigning progress. When you save a table, any other users in the project can use that table. This is useful if you want to set up standard tables for everyone to use, ensuring that everyone enters and edits information using the same interface.

The Line column displays the number of each spreadsheet row. Only rows that contain tasks are numbered: blank rows are not numbered. If you add or remove rows that contain tasks in between other rows, the spreadsheet rows are renumbered automatically.