Creating your first chart
From an empty workbook to a Gantt chart with real tasks on it. Ten minutes, one dialog — and one choice you make at the start that you cannot change afterwards.
Gantt Excel is an Excel workbook, not a separate program. You open it the way you open any other .xlsm file, and everything happens on ordinary worksheets, so your plan stays a spreadsheet you own and anyone with Excel can open it. Throughout these guides we build the same example, the Oakfield Villa build, so you can follow one project from its first task to a printed report. Guides about planning in hours use a kitchen refit instead, because nobody schedules a house by the hour.
01 Enable macros first
The schedule, the bars and the roll-ups are all calculated in VBA, and Excel blocks that code by default. Open the workbook, click Enable Content on the yellow bar under the ribbon, and you are done; Excel remembers the file after that.
If there is no yellow bar, or the Gantt Excel tab never appears, Enabling macros in Excel has the fix, covering both platforms, the blocked-file case, and a ribbon tab that is missing or unresponsive.
02 Opening the New Project dialog
With macros running, the Gantt Excel tab appears on the ribbon, to the left of Home. Most of what you will use is on it; a task row’s right-click menu holds the rest.
Click the Gantt Excel tab. In the Gantt Charts section, click Add New Gantt Chart.
The New Project dialog opens.
That is the whole creation flow. There is no wizard and no second page. One dialog produces a finished, formatted chart sheet with the timeline already drawn.
03 Filling in the dialog
Here is the whole New Project dialog. Hover or tap a pin for what each part does; the numbered key below lists them all.
- Project Name. The heading shown across the top of the chart sheet. Free text — spaces and punctuation are fine.
- Worksheet Name. The name on the Excel tab. Excel’s own rules apply: 31 characters maximum, and no ? \ / * [ ] : — those are stripped as you type or paste.
- Project Lead. Who owns the plan. Written into the header rows just under the project name.
- Duration is entered in. Days or Hours, Days to start with. It decides what a plain number means when you type a duration, a lag or Work: with Days, 7 is seven working days; with Hours, seven hours. A unit you type yourself (7h, 7d) always wins. You can change it later in Edit Project. Nothing already on the chart changes when you do, because every figure keeps the unit it was entered in. See section 04.
- Language. The language for this project’s labels and messages, stored per chart rather than per workbook.
- Enable Costs. Ticked by default. Untick it and the budget fields grey out and the money row is left blank.
- Budget Details. Baseline Budget and Estimated Budget for the project as a whole.
- Import Gantt Chart. Leaves this dialog and starts the import flow instead — for bringing a chart in from another Gantt Excel workbook. It asks
Import a project from another Gantt Excel workbook. Continue?
before it goes anywhere; answering No closes the dialog without creating anything.
04 One kind of chart for days and hours
There is no choice to make between a days chart and an hours chart any more. Every new chart is the same kind of chart, and it plans in working days and in hours on the same sheet. The Duration is entered in box only sets what a plain number means.
“Is this project measured in working days?”
A new chart opens the way most projects are planned: in the Daily View, on a 35-day timeline that starts at the beginning of the current week, with a first task one working day long. Type a plain number such as 5, or 5d, and the task is that many working days long. Weekends and holidays are skipped.
“Does part of it run inside the working day?”
The same chart takes hours and minutes: type 4h or 90m. If most of your tasks are measured in hours, set Duration is entered in to Hours and a plain number is read as hours instead. Dates show the day only until you ask for times as well (Settings, General tab), and Hourly View on the ribbon shows the chart one hour per column. New charts plan on a 15-minute increment.
Charts made in older versions keep the kind they were created as. An old daily chart goes on working in whole days. Import one into a new workbook and it arrives as the new kind of chart, still reading in days, with its dates kept; see Importing Gantt charts.
05 What you get
Click OK and a new sheet appears, already formatted, with a timeline drawn across it. Reading down the left of the sheet:
- The project name sits in a white card at the top, with the name itself in the project colour. Click the card to reopen Edit Project.
- The project lead is on the line beneath it, and the budget line under that when costs are enabled.
- The column headers sit on the row directly above the first task: Task, Priority, Status, the date columns, % Complete, Resources and the rest.
- One starter task is already there, named
Type here or double-click to edit in form.
at Priority Normal, Status Not Started and 0% complete. It starts at the first working time on or after today, so on a weekend or a holiday it starts on the next working day, and it runs for 1 day. With Duration is entered in set to Hours the same day is written in hours, for example 8h. - A grey italic placeholder row underneath it reading
Type here to add a new task
. That row is how you add tasks by typing.
Two more sheets are created at the same time and hidden, one holding this project’s settings and one holding its resources. You never edit them by hand. The Settings dialog and the Resources dialog are how you reach what is in them. The resource list starts with a single calendar, This plan’s calendar, working Monday to Friday, which is what every task schedules against until you change it or assign someone.
06 Adding your first tasks
There are two ways in.
Type straight into the sheet. Click the starter task’s name, type over it, and press Enter. Then click the grey Type here to add a new task
row and type the next one. This is the fastest way to get a list of tasks down while you are still thinking. Gantt Excel fills in sensible dates as you go, and you can fix them afterwards.
Use the form. Gantt Excel → Tasks → Add Task opens the Task Form on a new row.
You can set the name, dates, duration, resource and progress in one pass. Double-clicking any existing task row opens the same form on that task. The whole form is covered in The Task Form.
Try it now with the first three tasks of the villa build. Enter each Task name, its Start and its Duration, and leave Finish alone, because Gantt Excel calculates it for you on the default Monday–Friday working week. Type the durations as plain numbers, 2, 6 and 8: a new chart reads them as working days.
| Task | Start | Duration | Finish (calculated) |
|---|---|---|---|
| Client brief | Mon 29 June | 2 days | Tue 30 June |
| Architectural drawings | Wed 1 July | 6 days | Wed 8 July |
| Planning permission | Thu 9 July | 8 days | Mon 20 July |
Check the second row against your own sheet: six days from Wednesday 1 July lands on Wednesday 8 July, not Monday 6 July, because the weekend is not counted. You supply a start and a duration; Gantt Excel works out the finish date around non-working days. The Resources guide explains how to change those working days and add holidays.
07 Changing the project details later
The name, lead, budgets and language are all editable after the fact. Either click the project name banner at the top of the sheet, or use Gantt Excel → Gantt Charts → Edit Project. The same dialog reopens, this time titled Edit Project Details, holding the project’s current values.
08 Where to go next
You now have a chart with tasks on it. The natural order from here:
- The Gantt Excel tab & your chart sheet — what every ribbon button and every column is for.
- The Task Form — the one place you edit everything about a task.
- Summary tasks, indenting & the WBS — turning a flat list into phases.
- Linking tasks with dependencies — so moving one task moves the ones that follow it.
- Resources, calendars & working days — who does the work, and which days they work.
09 Common questions
Where do I choose between Days and Hours?
The ribbon has no Gantt Excel tab. Where is it?
Automation Off – Enable Macros to Continue. Click Here for Help.Click Enable Content on the yellow bar; if there is no yellow bar, the file has been blocked outright and needs unblocking before Excel will ask you anything. Enabling macros in Excel walks through every cause, including a tab that is present but does nothing.
My budget figure vanished when I clicked out of the box.
Can I have several projects in one workbook?
What does Language on the dialog actually change?
Do I have to fill in the budgets?
Related: The Gantt Excel tab & your chart sheet · Adding, editing & deleting tasks · Planning by the hour