Gantt charts (timelines)
- Home
- Resources
- User manual
- thinkcell Charts: Data visualization
- Gantt charts (timelines)
Gantt charts are available with thinkcell Suite.
A project timeline or Gantt chart visualizes a project's schedule. A Gantt chart displays the project's time frame on the horizontal axis, and the project's activities or tasks on the vertical axis. Gantt charts show what tasks need to be done, when they start and finish, and how they relate to each other.
For general instructions on formatting Gantt charts and other thinkcell elements, see Format and style elements.
|
Icon in Elements menu: |
|
Calendar scales
Calendar scales show the duration of your project timeline on the chart's horizontal axis. Calendar scales include year, quarter, month, week, and day scales. You can modify the date range and appearance of calendar scales.
Modify the date range
When you insert a new Gantt chart, the calendar scales initially show the current month and the next two months. You can modify the chart's date range using a calendar scale or the Calendar dialog. If any Timeline items fall outside the selected date range, you can reset the date range so that all timeline items are visible.
You can change the date range by dragging the ends of a calendar scale.
- Select a calendar scale.
- Drag one of the blue arrows on the ends of the scale. While you drag, the new date is displayed in a tooltip below the arrow.
- When the tooltip shows the date that you want, release the mouse button. The chart updates to display the new date range.
When you drag a handle, the date changes in increments that correspond to the units of the selected scale. For example, if you drag a handle of the week scale, the date changes in one-week increments. To modify the date range faster, drag a handle of a scale with larger units—for example, a month or year scale.
To open the Calendar dialog, double-click a calendar scale. Alternatively, right-click a calendar scale to open the context menu, then select Open Calendar
In the Calendar dialog, today's date is highlighted in red. The upper-right corner shows the start date and end date of the selected range in ISO date format, and the length of the range.
You can use the following actions to modify the date range. Changes to the selected date range appear immediately in the chart.
|
To do this |
Do the following |
|---|---|
|
Modify the date range |
|
|
Scroll up and down |
|
|
Jump to a specific date |
Use the controls in the upper-left corner:
|
|
Change the range of dates that are visible in the Calendar dialog |
Resize the dialog vertically. |
|
Change the Calendar dialog font size |
Resize the dialog horizontally. |
To close the Calendar dialog, select Close
If you change the date range so that a timeline item is no longer visible, then expand the date range so that the item is visible again, thinkcell preserves any custom text and formatting for that item (see Timeline items).
To reset the date range so that all bars, process arrows, milestones, and brackets are visible (see Timeline items), right-click the chart to open the context menu, then select Fit Scale to Data
To delete hidden timeline items, use the clean-up option Invisible and Off-Slide Content (see Clean up and sanitize).
Add and remove calendar scales
Before you manually add or remove calendar scales, we recommend that you select the date range that you want (see Modify the date range). By default, thinkcell automatically adds and removes calendar scales depending on the date range, chart size, and font size. If you manually add a calendar scale, thinkcell won't remove the scale automatically, even when you change the chart's size or date range.
The following actions will turn off automatic adjustment of scales and separators:
- Manually add or remove calendar scales (see the following instructions).
- Manually add or remove calendar scale separators (see Calendar scale separators).
To restore automatic adjustment of all calendar scales and Calendar scale separators, select the chart or any scale to open the mini toolbar, then select Automatic Scales/Separators.
If you manually add a calendar scale, thinkcell won't hide the scale automatically when you change the chart size or date range.
To manually add a calendar scale, select the chart or any scale to open the mini toolbar. Under Scales, select the scale that you want to add:
- Years
- Quarters
- Months
- Weeks
- Days
To manually remove a calendar scale, do one of the following:
- Right-click the scale that you want to remove. On the context menu, select Delete
.
- Select the chart or any scale to open the mini toolbar. Under Scales, deselect the scale that you want to remove.
- Select the scale that you want to remove, then select Delete.
Format calendar scales
You can adjust how weekends appear in the chart, the day that the week starts on, and the format of dates. You can also show time in fiscal rather than calendar years.
To format and style calendar scale text, see Format and style text.
Change whether and how weekends appear in the chart.
- Select the chart or any scale to open the mini toolbar.
- On the Weekend Display menu, select one of the following:
- Plain Weekends: Weekends appear in the chart without shading.
- Shaded Weekends: Weekends appear in the chart with shading.
- Hidden Weekends: Weekends don't appear in the chart.
Choose which days of the week correspond to the weekend.
- Select the chart or any scale to open the mini toolbar.
- On the Weekend menu, select one of the following:
- Weekend: Thursday–Friday
- Weekend: Friday
- Weekend: Friday–Saturday
- Weekend: Saturday–Sunday
- Weekend: Sunday
Choose the day of the week that corresponds to the start of your week.
- Select the chart or any scale to open the mini toolbar.
- On the Week Starts On menu, choose the weekday that corresponds to the start of your week.
Change the date format of any calendar scale. For example, in the month scale, you can choose to display months as a two-digit numbers (01) or three-letter abbreviations (Jan), or you can display the full month name (January).
- Select the calendar scale whose date format you want to change.
- On the mini toolbar, in the Format box, do one of the following:
- On the dropdown menu, select the date format that you want.
- In the text box, enter the date format code that you want (see Date format codes).
The week scale has two possible date formats:
- Week number, as designated by the date format code
worww. Weeks are numbered according to ISO 8601. - The first date of each week, as designated by the date format code
dordd.
To learn more, see Date format control.
If a fiscal calendar is configured in the active style file, you can show time in fiscal rather than calendar years. To learn more, see Add fiscal calendar option to Gantt charts.
- Select the chart or any scale to open the mini toolbar.
- Select Fiscal Year.
Calendar scale separators
For any calendar scale, you can add or remove vertical lines that separate the units of the scale. thinkcell automatically uses solid lines for larger units and dashed lines for smaller units.
Before you manually add or remove calendar scale separators, we recommend that you select the date range that you want (see Modify the date range). By default, thinkcell adds and removes calendar scale separators depending on the date range, chart size, and font size. If you manually add separators for a calendar scale, thinkcell won't remove these separators automatically, even when you change the chart's size or date range.
The following actions will turn off automatic adjustment of scales and separators:
- Manually add or remove calendar scales (see Add and remove calendar scales).
- Manually add or remove calendar scale separators (see the following instructions).
To restore automatic adjustment of all calendar scales and separators, select the chart or any scale to open the mini toolbar, then select Automatic Scales/Separators.
If you manually add calendar scale separators, thinkcell won't hide them automatically when you change the chart size or date range, unless the separators can't fit in the chart.
To manually add calendar scale separators, select the chart or any scale to open the mini toolbar. Under Separators, select the separator type that you want to add:
- Years
- Quarters
- Months
- Weeks
- Days
Alternatively, right-click the scale for which you want to add separators. On the context menu, select Add Vertical Separator Lines
To manually remove calendar scale separators, do one of the following:
- Right-click a separator of the type that you want to remove. On the context menu, select Delete
.
- Right-click the scale for which you want to remove separators. On the context menu, select Remove Vertical Separator Lines
.
- Select the chart or any scale to open the mini toolbar. Under Separators, deselect the separator type that you want to remove.
- Select a separator of the type that you want to remove, then select Delete.
Calendar scale labels
You can add labels to any calendar scale. By default, the label displays the calendar scale type. For example, when you add a label to the month scale, the label is Month. The label language matches the proofing language of the current slide (see Language). You can customize this label text as needed.
To add a calendar scale label, right-click the scale to which you want to add a label. On the context menu, select Add Scale Label
To remove a calendar scale label, do one of the following:
- Right-click the label that you want to remove. On the context menu, select Delete
.
- Right-click the scale whose label you want to remove. On the context menu, select Remove Scale Label
.
- Select the label that you want to remove, then select Delete.
By default, the label displays the calendar scale type. For example, when you add a label to the month scale, the label is Month.
The week scale has two possible default labels, depending on the date format (see Change date formats):
- If the date format contains the week number, as designated by the date format code
worww, the label is Week. Weeks are numbered according to ISO 8601. - If the date format contains the first date of each week, as designated by the date format code
dordd, and does not contain the week number, the label is Week of.
You can enter new label text as needed, and you can change the format and style of the text (see Format and style text).
Rows (activities)
In a Gantt chart, rows represent activities. On the left side of the chart, activities are identified by row labels. Rows contain Timeline items such as bars, milestones, and brackets.
You can change the look of a row, add or remove row labels, drag a row to another location, or use Shift+Alt and the cursor keys ↑ and ↓ to move it.
Note: There is a special row below the chart reserved for the most important milestones. You cannot add bars to this row, you cannot move it by drag-and-drop, and you cannot delete it. Otherwise, it is just an additional activity row which is always there.
Add and remove rows
To insert a new row, open the context menu by right-clicking an existing row, then select
You can also duplicate a selected row using the keyboard shortcuts Ctrl+Alt+↑ and Ctrl+Alt+↓, creating a duplicate before or after the selected row, respectively. Using the keyboard shortcuts, you can add rows and keep typing without reaching for the mouse. Likewise, you can use Alt and the cursor keys ← → ↑ ↓ to move the cursor across labels.
To delete a row, open the context menu and select
Row features
Each row can contain timeline items, such as bars, process arrows, milestones, brackets. Rows can also have up to three labels, a horizontal separator line, and row shading. The labels and decorations are added and removed using the thinkcell context menu. To open the menu, move the mouse outside of the chart’s date range area and right-click on a row when it highlights.
Note: When you right-click a row inside the chart’s date range area, another menu opens that allows for insertion of new timeline items. Refer to Add, duplicate, and delete timeline items for more information.
The row’s context menu offers the following buttons. You can apply all of these buttons to one or multiple selected rows:
Delete the selected row.
Insert a new row after the selected row. You can also create a duplicate before or after the selected row using the keyboard shortcuts Ctrl+Alt+↑ and Ctrl+Alt+↓, respectively. If the selected row is the one below the chart’s bottom line, you can insert a new row using the keyboard shortcut Ctrl+Alt+↑.
Add or remove the activity label column. A headline for the column is added which you can overwrite or remove if necessary. With F2 you can edit the selected row’s activity label.
Add or remove the responsibility label column. A headline for the column is added which you can overwrite or remove if necessary.
Add or remove the remark label column. A headline for the column is added which you can overwrite or remove if necessary.
Add or remove shading. You can change the shading’s color and also add or remove the shading using the fill control on the thinkcell mini toolbar. Shading works also well for multiple successive rows.
Add or remove a separator line above the selected row.
Row labels
Each row supports up to three labels, resulting in up to three text columns next to the actual timeline. The default headlines for the three columns are language dependent (see Language), with “Activity,” “Responsible” and “Remark” used as the default English headlines. You are free to overwrite or remove them if necessary.
The labels to the left are intended for names of activities. These labels are shown by default and each label belongs to exactly one row. If you already have the text for the labels available in some other place where you can copy them to the clipboard, you can quickly paste an entire label column (see Paste text into multiple objects).
Note: Unfortunately, selecting multiple shapes in PowerPoint or labels in another Gantt chart does not work in this regard. Lines of text in a word processor, text editor or email or multiple cells in an Excel worksheet can be copied to the clipboard and pasted into activity labels as described above.
You can organize activity labels in a hierarchy using PowerPoint’s Decrease/Increase List Level buttons in the Paragraph ribbon group on the Home tab. Alternatively, hold down Shift+Alt and use the arrow keys ← and →. The vertical space between indented labels is reduced to show that they are grouped.
You can add up to two more columns if required. The labels for the headlines are automatically added when a column is created. The labels in the additional columns can refer to multiple rows (see Labels spanning multiple rows).
Initially, a newly created label column is empty except for its headline. Move the mouse over the label column to discover label placeholders, which you can select just as any other features in thinkcell. Use the placeholder’s context menu to create either a text label, or a checkbox, or a Harvey ball. To quickly create a text label, you can simply select a placeholder and start typing. Similarly, you can recreate the headline labels, if you deleted them.
The row label’s context menu shows the following buttons:
Delete the selected label.
Use a checkbox instead of a text label (see Checkboxes). If the selected label already contains text, the text will be discarded.
Use a Harvey ball instead of a text label (see Checkboxes). If the selected label already contains text, the text will be discarded.
Use text for this label. Select and overwrite the placeholder text that is inserted when you click this button.
Add or remove the selected label’s bracket. Brackets are added automatically to labels that span more than one row (see Labels spanning multiple rows). This option only applies to responsibility and remark labels. Since activity labels always refer to precisely one row, these labels do not need brackets.
To remove a label, use its context menu or simply delete all text from the label—it will then disappear. To remove multiple labels at a time, it is often convenient to select all desired labels using the mouse together with Shift or Ctrl keys (see also Select objects with your mouse). Then, choose the delete option from the context menu, or press the Del key to remove all selected labels.
Labels spanning multiple rows
In both responsibility and remark columns, each label can refer to more than one activity. Drag the handles that appear next to the label when you select it, to determine the activities it refers to. You can only drag a label’s handles across rows that do not already have a label in the same column, and you cannot drag the handles across horizontal separators.
A bracket will automatically appear as soon as a label spans more than one row. In this case, you are free to remove the bracket by selecting it and pressing Del, or via the bracket’s or the label’s context menu.
Timeline items
Timeline items visualize events in your project timeline.
Types of timeline items
Timeline items include bars, process arrows, milestones, brackets, and shades.
Bars indicate the duration of an activity.
Pentagons and chevrons, also known as process arrows, indicate the duration of an activity and can contain text.
Milestones indicate single-day occurrences. Add milestones that affect an individual activity to that activity's row. Add milestones that affect multiple activities below the chart.
You can add milestone lines to milestones (see Format and style milestones). Milestone lines span all activity rows in the chart.
Brackets label periods of time.
Shades indicate periods of time, such as holidays, that affect activities throughout the chart.
By default, when you insert a shade, a bracket with a date label is anchored to it (see Add and remove anchors). You can move the bracket vertically along the shade, remove the bracket's anchors to position it independently, or delete the bracket.
Add, duplicate, and delete timeline items
Learn how to add, duplicate, and delete timeline items.
You can add any timeline item to the timeline area of a Gantt chart. Below the timeline area, you can also add milestones, brackets, and shades.
- Move your pointer over or below the timeline area. Red crosshairs help you locate the date and activity row where you want to insert an item. A tooltip shows the date, weekday, and week number.
- Right-click where you want to add the item. On the context menu, select the item that you want:
- New Bar
: Add a bar that starts on the date that you've selected.
- New Milestone
: Add a milestone on the date that you've selected.
- New Bracket
: Add a bracket that starts on the date that you've selected.
- New Shade
: Add a shade that starts on the date that you've selected.
-
New Pentagon/Chevron
: Add a process arrow that starts on the date that you've selected.
- New Bar
The dates that you can select using the crosshairs depend on the chart's date range, the chart's size, and your zoom setting. If the date range is too compressed to select a certain calendar unit, the crosshairs snap to the next largest calendar unit. For example, if the date range is too compressed to select individual dates, the crosshairs snap to the first dates of weeks and months.
To duplicate a timeline item, hold down Ctrl and drag the item to a new position. A copy of the original item is added at the new position.
To delete timeline items, do one of the following:
- Right-click an item to open the context menu, then select Delete
.
- Select multiple items. Right-click the selection to open the context menu, then select Delete
.
- Select one or more items, then select Delete.
To delete timeline items outside of the selected date range (see Hidden timeline items), use the clean-up option Invisible and Off-Slide Content (see Clean up and sanitize).
Move timeline items
Move timeline items across activity rows, or adjust their dates.
To move timeline items into another activity row, drag one or more items into the row that you want (see Select objects).
When you drag a timeline item’s handle, the date changes but the item remains in the same row. To move an item into a different row, drag the item itself, not its handles.
To adjust the dates of timeline items, do one of the following:
- Drag one or more items to the date or date range that you want (see Select objects).
- Select a bar, process arrow, shade, or bracket, then drag its handles to the start and end dates that you want.
- Double-click an item, or select Open Calendar
on the item's context menu. In the Calendar dialog, select the date or date range that you want (see Modify the date range).
- For bars, process arrows, shades, and brackets, close the dialog after you've selected the date range that you want.
- For milestones, the dialog closes automatically after you select a date.
If a bar’s start or end date falls outside the timeline’s date range, an arrow appears at the corresponding end of the bar.
Add and remove anchors
You can anchor timeline items to each other so that their dates are linked. For example, when you change a milestone's date, any items that are anchored to the milestone update to match the new date.
To anchor one timeline item to another, follow these steps:
- Select the timeline item that you want to anchor—for example, select a bar.
- Start dragging the handle that you want to anchor—for example, the handle at the bar's start date. Available anchor points appear.
- Drag the handle to the anchor point that you want to link to—for example, the anchor point of a milestone—so that a blue anchor icon appears.
If you want to position one timeline item adjacent to another item without creating an anchor, when you drag an item's handle, drag above or below the adjacent handle so that the blue anchor icon disappears.
To remove an anchor, follow these steps:
- Select the timeline item from which you created the anchor. For example, if you anchored a bar to a milestone, select the bar.
- On the timeline item to which you attached the anchor—for example, the milestone—drag the handle with the anchor icon up or down so that the anchor icon disappears.
Timeline item labels
Timeline item labels can contain custom text, an item’s date or date range, or both. If you change an item’s date, any date information in its label updates automatically. You can edit label text and reposition labels.
For more information on labels, see Chart labels.
When you add a label to a timeline item, the label initially contains either custom text or the item’s date or date range. You can add labels directly to bars, process arrows, milestones, and brackets. To label a shade, add a bracket.
Milestones and brackets have date labels by default. You can add to or replace the label content (see Edit timeline item labels).
Add custom labels
To add a label that contains custom text to a bar, process arrow, milestone, or bracket, follow these steps:
- Select the timeline item to which you want to add a label.
- When you start typing, thinkcell adds a label or overwrites existing label content. Enter the label text that you want.
Add date labels
Date labels contain date fields that show an item's date or date range. If you change an item's date, the date field updates automatically.
To add date labels to bars, milestones, or brackets, follow these steps:
- Select one or more timeline items to which you want to add a label.
- Right-click your selection to open the context menu, then select Add Date Label
. Alternatively, if you've only selected one timeline item, select F2.
To add date labels to process arrows, follow these steps:
- Select one or more process arrows to which you want to add a label.
- Do one of the following:
- On the mini toolbar, on the Label Content menu, select the date content that you want.
- Right-click your selection to open the context menu, then select Add Text
.
- If you've only selected one process arrow, select F2.
Add labels to shades
By default, shades include a bracket with a date label. If you delete the bracket, you can add it again as follows:
- Add a bracket (see Add timeline items).
- Anchor the start and end dates of the bracket to the start and end dates of the shade (see Add anchors).
Brackets have a date label by default. You can add to or replace the label content (see Edit timeline item labels).
To remove a label from a bar, milestone, or bracket, do one of the following:
- Right-click the timeline item whose label you want to remove. On the context menu, select Remove Date Label
.
- Right-click the label that you want to remove. On the context menu, select Delete
.
- Select the label that you want to remove, then select Delete.
To remove a label from a process arrow, right-click the process arrow. On the context menu, select Remove Text
To remove a label from a shade, remove the bracket that's anchored to the shade (see Delete timeline items).
You can enter any text in a timeline item label. If a timeline item label contains a date field, you can add text or replace the date fields with your own text. To replace existing text in a timeline item label, select the item, then start typing.
Gantt charts support large, multiline labels. Activity rows and process arrows automatically adjust their height to fit label contents. If possible, thinkcell matches the heights of all process arrows.
To format and style text in timeline item labels, see Format and style text.
Edit date field content
Choose which date information to show in a label's date field. For example, you can show an item’s date range, start date, or end date.
To change the date format, see Date format control.
To change date field content, follow these steps:
- Select the label whose date field content you want to change.
- On the mini toolbar, open the Label Content menu, then select the date information that you want:
- For bars, process arrows, and brackets, select one of the following:
- Date Range (default)
- Start Date
- End Date
- For milestones, select one of the following:
- Date (default)
- Previous Day (default if anchored to the end date of a multiday timeline item; see Milestone position)
- For bars, process arrows, and brackets, select one of the following:
Restore date fields
To restore a date field after you've deleted it, follow these steps:
- Select the label to which you want to add the date field.
- On the mini toolbar, open the Label Content menu and select the date information that you want to show.
By default, thinkcell automatically chooses the position of timeline item labels based on the chart's layout.
When you manually position a label, thinkcell keeps this position, even if the chart's layout changes. To manually position a label, follow these steps:
- Hover over or select the label that you want to move.
- Start dragging the move icon at the bottom-right corner of the label. Available label positions appear on or around the timeline item.
- Drag the label to the position that you want.
Restore automatic label placement
To restore automatic label placement, do one of the following:
- Right-click the label to open the context menu. Select Enable automatic placement
.
- Drag the label to Drag here for Automatic on the left side of the slide.
Format and style timeline items
You can change the look of bars, process arrows, milestones, and shades. To format and style timeline item labels, see Edit timeline item labels.
You can change the fill and outline of bars.
- Select one or more bars to open the mini toolbar.
- On the mini toolbar, select any of the following:
- Shape Style: Select a default style that's defined in your style file (see Style files), or another bar style that you currently use in the chart.
- Fill: Select a fill (see Fills).
- Outline Color: Select an outline color (see Change the outline color).
- Line Style: Select an outline style.
You can change the fill and outline of process arrows.
- Select one or more process arrows to open the mini toolbar.
- On the mini toolbar, select any of the following:
- Shape Style: Select a default style that's defined in your style file (see Style files), or another process arrow style based on what you currently use in your chart.
- Fill: Select a fill (see Fills).
- Outline Color: Select an outline color (see Change the outline color).
- Line Style: Select an outline style.
You can change the marker shape and color of milestones, and add milestone lines that span activities throughout the chart.
To change the marker shape and color of milestones, follow these steps:
- Select one or more milestones to open the mini toolbar.
- On the mini toolbar, select any of the following:
- Marker Style: Select a marker shape.
- Marker Color: Select a marker color (see Fills).
Add and remove milestone lines
To add milestone lines, follow these steps:
- Select one or more milestones.
- Right-click your selection to open the context menu, then select Add Milestone Line
.
To remove milestone lines, do one of the following:
- Select the milestone lines that you want to remove, then select Delete.
- Select the milestones whose milestone lines you want to remove. Right-click your selection to open the context menu, then select Remove Milestone Line
.
You can change a shade's fill.
- Select one or more shades to open the mini toolbar.
- On the mini toolbar, open the Fill menu, then a fill (see Fills).
Milestone position
If the day scale or day separators are visible (see Calendar scales), thinkcell positions milestones in the middle of the day.
If neither the day scale nor day separators are visible, thinkcell positions milestones at the beginning of the day.
If you anchor a milestone to the end date of a bar, process arrow, bracket, or shade (see Add and remove anchors), thinkcell positions the milestone at the end of the day, and any date field content changes to Previous Day (see Edit timeline item labels).
If you anchor a milestone to the start date of a bar, process arrow, bracket, or shade, thinkcell positions the milestone at the beginning of the day.
Datasheets
Gantt charts can use dates that are stored in a datasheet. You can then anchor timeline items to those dates. If dates in the datasheet change, the anchored timeline items are updated accordingly.
This is similar to chart types which are based on numbers. In these chart types, the datasheet contains numerical values, and the chart is updated when numbers change. However, you also control the visualization of your data and add arrows and value lines in the chart, not in the datasheet.
Let’s say you want to create a Gantt chart with five activities that each have their result validated at a milestone a few weeks after completion. You want to store all dates in the datasheet to easily update them later in a single window.
You start by inserting a Gantt chart. Open the datasheet by clicking the Open Datasheet button in the bottom right corner of the Gantt chart.
The first row in the datasheet corresponds to the milestone row below the Gantt chart. Into the second row, you enter the first activity description and three dates: the start of the task, the end and the validation milestone, respectively.
Note: You need to enter the dates in a way that Excel recognizes as dates. If the cell content is right-aligned, Excel has recognized a date. Otherwise, Excel has only recognized your input as text, and thinkcell will not be able to use it. When specifying a date and not including a time, Excel will assume the time to be 12:00am, i.e., the beginning of that day. When such a date is used as the end of an activity, the activity therefore is displayed as ending on 12:00am of that day, i.e., not including the day itself. If you want to specify that an activity ends with January 15th and includes that day, either enter 2017-01-15 11:59pm or 2017-01-16.
You will notice two changes in the Gantt chart:
- Three anchor points are displayed at the top of the first row, corresponding to the dates you entered into the datasheet.
- A green line down the left of the first row indicates that this row is linked to the datasheet. The tooltip for the row contains the specific source: "Linked to sheet row 2."
Now it is time to anchor timeline items to the dates from the datasheet:
- Select the bar that remains from the default Gantt chart and anchor the beginning to the first anchor and the end to the second anchor.
- Insert a milestone and anchor it to the third anchor.
Note: If multiple timeline items are selected in different rows and a handle is dragged to an anchor from the datasheet, each item is appropriately anchored to the respective date from its own linked datasheet row.
Feel free to remove the other five standard rows that are not linked to the datasheet. Once you fill additional rows in the datasheet, corresponding activity rows will automatically be added to the Gantt chart as needed.
At this point, you finish entering activity titles and dates into the datasheet:
While you type in the additional tasks and dates in the datasheet, the Gantt chart is automatically updated:
- Once you start filling a new row in the datasheet, an activity row is added to the Gantt chart.
- As you add dates to the datasheet, new timeline items are added to the Gantt chart. The new items are modelled on the items in the existing row above the new row.
- New timeline items, i.e., the new activity bar and the new milestone, are automatically anchored in the same manner as those in the closest row—in this example, the row above. Of course, if the dates in the datasheet differ from row to row, the positions of the timeline items in the Gantt chart reflect this.
You have quickly created a complete Gantt chart with five rows and two items per row.
After you have defined the general structure in the first row, subsequent rows have automatically followed this structure without any more inserting and anchoring necessary.
Excel links
A Gantt chart can be linked to a range in an Excel file (see Excel data links). Let’s assume that the dates from the example above reside in an Excel file you received:
To create a linked Gantt chart, follow these steps:
- Select all cells in Excel, including the activity titles and the dates.
- Include in your selection an additional row above the first activity title and dates. This additional row holds dates for the Gantt chart’s milestone row. Even if no such dates are present, this row needs to be included in your selection.
- From the Charts menu in Excel’s thinkcell toolbar, select the chart type Gantt/Timeline.
- In PowerPoint, choose the appropriate slide and position for the new Gantt chart.
The range in Excel will be marked as linked:
The new Gantt chart will show your activity titles and the anchors for the dates in Excel, but no timeline items yet:
You can now insert timeline items like bars and milestones and link them to the anchors corresponding to dates in Excel.
To quickly populate the Gantt chart, please
- Insert and anchor items in the first activity row: one bar between the first two anchors and a milestone at the third anchor.
- Select all timeline items in the first row.
- Drag the items to the second row while holding down the Shift and Ctrl keys. In PowerPoint, a drag operation such as this would duplicate shapes while keeping them aligned. In thinkcell, the result is the same: the timeline items are duplicated and aligned—anchored—to the respective anchors in the second row.
- Repeat for the other rows.
Using drag & drop while holding down Shift and Ctrl you can quickly fill the Gantt chart with timeline items. If the dates in Excel change, the Gantt chart is updated as described in Manage the data in linked elements.
Date format control
You can freely set the desired formatting for date values that appear throughout the labels of a project timeline. All item labels of a chart share the same date formatting, so when you change the formatting for one label, all others will change accordingly.
When you select a label that contains a date field, or select a date field within a label, the date format control appears on the mini toolbar. It works similarly to the number format control (see Number format).
The dropdown menu facilitates one-click selection of the most commonly used date formats. Its contents depend on the feature that is selected, e.g., each scale offers a different set of predefined date formats. Also, up to four of your most recently used custom formats are available in the dropdown box.
The edit box reflects the current setting and allows entering of custom date formats. Excel's format codes are supported, and some more codes were added for the particular purposes of the project timeline (see table in Date format codes).
Date format codes are case-insensitive.
Insert a line break with a pilcrow (¶) using the shortcut Alt+Enter (Windows) or Option+Return (Mac).
Mix format codes with custom text and characters to create your own labels. To use characters in custom labels that are part of format codes (d D w W m M q Q y Y \), do one of the following:
- Enclose text that contains format-code characters in single or double quotation marks ('...' or "...").
- Enter a backslash (\) before a single format-code character.
To use a single quotation mark in custom labels, enter one quotation mark (') or two quotation marks consecutively ('').
Language
A Gantt chart's labels and calendar scales match the proofing language of the current slide.
A Gantt chart's layout also adapts to the reading direction of the proofing language. If the proofing language is a right-to-left language, such as Arabic or Hebrew, the Activity column appears on the right side of the chart, the timeline progresses from right to left, and the Responsible and Remark columns appear on the left side of the chart.
We recommend that before you insert a Gantt chart onto your slide, you ensure that the current slide uses the proofing language that you want (see Change the proofing language).
If you change the proofing language after you've inserted a Gantt chart, or if you paste the chart onto a slide that has a different proofing language, you'll need to remove and re-add the labels and calendar scales to match the new language.
Date format codes
|
Code |
Description |
Example |
|---|---|---|
|
|
day of month |
5 |
|
|
day of month (two-digit) |
05 |
|
|
day of week (abbreviated) |
Mon |
|
|
day of week (full) |
Monday |
|
|
day of week (single character) |
M |
|
|
week of year |
7 |
|
|
week of year (two-digit) |
07 |
|
|
"Week" + week of year |
Week 7 |
|
|
"Week" + week of year (two-digit) |
Week 07 |
|
|
month number |
9 |
|
|
month number (two-digit) |
09 |
|
|
month name (abbreviated) |
Sep |
|
|
month name (full) |
September |
|
|
month name (single character) |
S |
|
|
quarter (Arabic numeral) |
4 |
|
|
quarter (lowercase Roman numeral) |
iv |
|
|
quarter (uppercase Roman numeral) |
IV |
|
|
year (two-digit) |
04 |
|
|
year (four-digit) |
2024 |
|
backslash ( |
custom character, e.g., |
Q3 |
|
quotation marks ( |
custom text, e.g., |
Quarter IV |
|
one or two single quotation marks ( |
single quotation mark, e.g., |
Jul '24 |
|
pilcrow ( Alt+Enter (Windows) or Option+Return (Mac) |
line break, e.g., |
Mon |
Need to troubleshoot?
Check our knowledge base