Gantt charts (timelines)

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.

Modify the date range using calendar scales

You can change the date range by dragging the ends of a calendar scale.

  1. Select a calendar scale.
  2. 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.
  3. 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.

Modify the date range using the Calendar dialog

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 image .

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

  • Select a start date, hold Shift, then select an end date.
  • Hold Shift, then use the arrow keys, Page up, or Page down.
  • Drag the mouse pointer over the range that you want.
  • Drag the white handles at either end of the selected range.

Scroll up and down

  • Rotate the mouse wheel.
  • Use the scroll bar.
  • Select Page up or Page down.

Jump to a specific date

Use the controls in the upper-left corner:

  • On the dropdown menu, select the month that you want.
  • In the text box, enter the year that you want. Alternatively, use the arrow buttons beside the text box.

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 , or select the main PowerPoint window.

Hidden timeline items

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 image .

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.

Manually add calendar scales

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

Manually remove calendar scales

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 Delete icon .
  • 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 how weekends are displayed

Change whether and how weekends appear in the chart.

  1. Select the chart or any scale to open the mini toolbar.
  2. 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.

Change the weekend days

Choose which days of the week correspond to the weekend.

  1. Select the chart or any scale to open the mini toolbar.
  2. On the Weekend menu, select one of the following:
    • Weekend: Thursday–Friday
    • Weekend: Friday
    • Weekend: Friday–Saturday
    • Weekend: Saturday–Sunday
    • Weekend: Sunday

Change the first day of the week

Choose the day of the week that corresponds to the start of your week.

  1. Select the chart or any scale to open the mini toolbar.
  2. On the Week Starts On menu, choose the weekday that corresponds to the start of your week.

Change date formats

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).

  1. Select the calendar scale whose date format you want to change.
  2. 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 w or ww. Weeks are numbered according to ISO 8601.
  • The first date of each week, as designated by the date format code d or dd.

To learn more, see Date format control.

Use fiscal years

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.

  1. Select the chart or any scale to open the mini toolbar.
  2. 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.

Manually add 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 image .

Manually remove separators

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 Delete icon .
  • 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.

Add calendar scale labels

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 image .

Remove calendar scale labels

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 Delete icon .
  • 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.

Edit calendar scale labels

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 w or ww, 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 d or dd, 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.

thinkcell Gantt chart row menu

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 image  Insert Row. If there are no rows in the chart area, you can right-click the chart area, then on the context menu select image  Insert Row. When you insert a new row, the first label of the newly inserted row is automatically selected.

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 Delete icon  Delete. Alternatively, use the keyboard shortcut Del.

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 icon Delete (Shortcut Del)
Delete the selected row.

image Insert Row (Shortcut Ctrl+Alt+ and Ctrl+Alt+)
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+.

image Add Activity Label Column (Shortcut F2)
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.

image Add Responsible Label Column
Add or remove the responsibility label column. A headline for the column is added which you can overwrite or remove if necessary.

image Add Remark Label Column
Add or remove the remark label column. A headline for the column is added which you can overwrite or remove if necessary.

image Add Row Shade
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.

image Add Row Separator
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 icon Delete (Shortcut Del)
Delete the selected label.

image Switch to Checkbox
Use a checkbox instead of a text label (see Checkboxes). If the selected label already contains text, the text will be discarded.

image Switch to Harvey ball
Use a Harvey ball instead of a text label (see Checkboxes). If the selected label already contains text, the text will be discarded.

image Switch to Text Label
Use text for this label. Select and overwrite the placeholder text that is inserted when you click this button.

image Add Bracket
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.

Labels spanning multiple rows in thinkcell Gantt chart

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.

Multi-row labels in thinkcell Gantt chart

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

Bars indicate the duration of an activity.

Process arrows

Pentagons and chevrons, also known as process arrows, indicate the duration of an activity and can contain text.

Milestones

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

Brackets label periods of time.

Shades

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.

Add 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.

  1. 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.
  2. Right-click where you want to add the item. On the context menu, select the item that you want:
    • New Bar image : Add a bar that starts on the date that you've selected.
    • New Milestone image : Add a milestone on the date that you've selected.
    • New Bracket image : Add a bracket that starts on the date that you've selected.
    • New Shade image : Add a shade that starts on the date that you've selected.
    • New Pentagon/Chevron image : Add a process arrow that starts on the date that you've selected.

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.

Duplicate timeline items

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.

Delete timeline items

To delete timeline items, do one of the following:

  • Right-click an item to open the context menu, then select Delete Delete icon .
  • Select multiple items. Right-click the selection to open the context menu, then select Delete Delete icon .
  • 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.

Move timeline items into different activity rows

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.

Adjust the dates of timeline items

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 image 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.

Add anchors

To anchor one timeline item to another, follow these steps:

  1. Select the timeline item that you want to anchor—for example, select a bar.
  2. Start dragging the handle that you want to anchor—for example, the handle at the bar's start date. Available anchor points appear.
  3. 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.

Remove anchors

To remove an anchor, follow these steps:

  1. Select the timeline item from which you created the anchor. For example, if you anchored a bar to a milestone, select the bar.
  2. 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.

Add timeline item 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:

  1. Select the timeline item to which you want to add a label.
  1. 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:

  1. Select one or more timeline items to which you want to add a label.
  2. Right-click your selection to open the context menu, then select Add Date Label image . Alternatively, if you've only selected one timeline item, select F2.

To add date labels to process arrows, follow these steps:

  1. Select one or more process arrows to which you want to add a label.
  2. 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 image .
    • 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:

  1. Add a bracket (see Add timeline items).
  2. 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).

Remove 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 Delete icon .
  • 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).

Edit timeline item labels

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:

  1. Select the label whose date field content you want to change.
  2. 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)
Restore date fields

To restore a date field after you've deleted it, follow these steps:

  1. Select the label to which you want to add the date field.
  2. On the mini toolbar, open the Label Content menu and select the date information that you want to show.
Move timeline item labels

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:

  1. Hover over or select the label that you want to move.
  2. Start dragging the move icon at the bottom-right corner of the label. Available label positions appear on or around the timeline item.
  3. 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.

Format and style bars

You can change the fill and outline of bars.

  1. Select one or more bars to open the mini toolbar.
  2. 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.
Format and style process arrows

You can change the fill and outline of process arrows.

  1. Select one or more process arrows to open the mini toolbar.
  2. 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.

Format and style milestones

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:

  1. Select one or more milestones to open the mini toolbar.
  2. 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:

  1. Select one or more milestones.
  2. Right-click your selection to open the context menu, then select Add Milestone Line gantt milestone line button .

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 .
Format and style shades

You can change a shade's fill.

  1. Select one or more shades to open the mini toolbar.
  2. 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.

Empty datasheet for a 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.

Gantt chart datasheet with dates for one row

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:

Gantt chart with one activity row linked to the datasheet

  • 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:

  1. 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.
  2. Insert a milestone and anchor it to the third anchor.

Gantt chart activity row with timeline items linked to the datasheet

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:

Gantt chart datasheet with dates for five rows

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.

Gantt chart with all timeline items linked to the datasheet

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.

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:

Excel range with dates before linking to a Gantt chart

To create a linked Gantt chart, follow these steps:

  1. Select all cells in Excel, including the activity titles and the dates.
  2. 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.
  3. From the Charts menu in Excel’s thinkcell toolbar, select the chart type Gantt/Timeline.
  4. In PowerPoint, choose the appropriate slide and position for the new Gantt chart.

The range in Excel will be marked as linked:

Excel range with dates after linking to a Gantt chart

The new Gantt chart will show your activity titles and the anchors for the dates in Excel, but no timeline items yet:

Gantt chart with anchors from Excel, but no timeline items

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

  1. Insert and anchor items in the first activity row: one bar between the first two anchors and a milestone at the third anchor.
  2. Select all timeline items in the first row.
  3. 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.
  4. 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 ('').

image

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

d

day of month

5

dd

day of month (two-digit)

05

ddd

day of week (abbreviated)

Mon

dddd

day of week (full)

Monday

ddddd

day of week (single character)

M

w

week of year

7

ww

week of year (two-digit)

07

www

"Week" + week of year

Week 7

wwww

"Week" + week of year (two-digit)

Week 07

M

month number

9

MM

month number (two-digit)

09

MMM

month name (abbreviated)

Sep

MMMM

month name (full)

September

MMMMM

month name (single character)

S

Q

quarter (Arabic numeral)

4

QQ

quarter (lowercase Roman numeral)

iv

QQQ

quarter (uppercase Roman numeral)

IV

yy

year (two-digit)

04

yyyy

year (four-digit)

2024

backslash (\)

custom character, e.g., \QQ

Q3

quotation marks ('...' or "...")

custom text, e.g., "Quarter" QQQ

Quarter IV

one or two single quotation marks (' or '')

single quotation mark, e.g., MMM 'yy

Jul '24

pilcrow ()

Alt+Enter (Windows) or Option+Return (Mac)

line break, e.g., ddd¶dd

Mon
24


Related topics

To learn more about creating timelines in PowerPoint, read this blog article.

Need to troubleshoot?

Check our knowledge base