Sign in with Microsoft
Sign in or create an account.
Hello,
Select a different account.
You have multiple accounts
Choose the account you want to sign in with.

Column type

Select a predefined column type or user-defined column type. (Column types are listed alphabetically, so user-defined columns appear at the end of the list.)

Note: If you add more than one user-defined text column, select a different column number each time. For example, the first time you add a column, select User Defined Text 1 from the Column type list. The second time you add a column, select User Defined Text 2.

Entering data in Gantt chart columns

This table shows the type of data you can enter into each type of column and the pattern to use to input the data.

Column type

Data type

Input pattern

% Complete

Decimal

X[.X][%]

Actual Duration

Decimal

X[.X][u]

For units, use d (days), m (minutes), h (hours), or w (weeks).

Actual Finish

Date

XX/XX/XXXX

Actual Start

Date

XX/XX/XXXX

Duration

Decimal

X[.X][u]

For units, use d (days), m (minutes), h (hours), or w (weeks).

Finish

Date

XX/XX/XXXX

ID

Integer

Will not accept input.

Outline Level

Integer (greater than 0)

X

Resource Names

Text

A*

Start

Date

XX/XX/XXXX

Task Name

Text

A*

Task Notes

Text

A*

User Defined Decimal

Decimal

X[.X][%]

User Defined Duration

Decimal

X[.X][u]

User Defined Number

Integer

X

User Defined Text 1-5

Text

A*

Need more help?

Want more options?

Explore subscription benefits, browse training courses, learn how to secure your device, and more.

Communities help you ask and answer questions, give feedback, and hear from experts with rich knowledge.

Was this information helpful?

What affected your experience?
By pressing submit, your feedback will be used to improve Microsoft products and services. Your IT admin will be able to collect this data. Privacy Statement.

Thank you for your feedback!

×