Documentation / Getting started / Creating your first chart

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.

1

Click the Gantt Excel tab. In the Gantt Charts section, click Add New Gantt Chart.

The Gantt Charts section of the Gantt Excel ribbon tab, with four buttons in a row: Add New Gantt Chart, Edit Project, Dashboard and Web Report
2

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.

The New Project dialog filled in for the Oakfield Villa Build example, with the worksheet name, project lead, Days duration and both budget figures
  1. Project Name. The heading shown across the top of the chart sheet. Free text — spaces and punctuation are fine.
  2. 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.
  3. Project Lead. Who owns the plan. Written into the header rows just under the project name.
  4. 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.
  5. Language. The language for this project’s labels and messages, stored per chart rather than per workbook.
  6. Enable Costs. Ticked by default. Untick it and the budget fields grey out and the money row is left blank.
  7. Budget Details. Baseline Budget and Estimated Budget for the project as a whole.
  8. 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.
Hover or tap a numbered pin to see what each field does.

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.

IN DAYS

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

IN HOURS

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

A brand-new daily chart seconds after creation: the Oakfield Villa Build banner, the project lead and budget lines, the column headers, one starter task dated Fri 14-Aug-26 for 1 day at 0% complete, and the grey Type here to add a new task row beneath it
A new chart, seconds old — one starter task, and the timeline already drawn.
  • 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.

The Add Task button in the Tasks section of the Gantt Excel ribbon - a blue list icon with a green plus badge
The Add Task button, in the Tasks section of the ribbon.

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.

TaskStartDurationFinish (calculated)
Client briefMon 29 June2 daysTue 30 June
Architectural drawingsWed 1 July6 daysWed 8 July
Planning permissionThu 9 July8 daysMon 20 July
The Oakfield Villa sheet with the three example tasks entered - Client brief, Architectural drawings and Planning permission - their dates and durations filled in and their bars drawn on the July 2026 timeline, with the grey Type here to add a new task row beneath
Type into the grey row and a new task appears, bar and all.

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:

09 Common questions

Where do I choose between Days and Hours?
Nowhere: you no longer have to. Every new chart takes both, so you can give one task 5d and the next 3h. A chart made in an older version keeps the kind it was created as. To bring an old daily chart onto the new kind, import it into a workbook (Importing Gantt charts): it arrives as the new kind of chart, with its dates and its durations in days kept.
The ribbon has no Gantt Excel tab. Where is it?
Macros are not running, so nothing on the tab responds. Gantt Excel says so on the sheet itself, in a red notice reading 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.
The budget fields accept a positive number only, and silently clear anything else. There is no error message. Retype the figure as plain digits with no currency symbol, for example 385000; it is reformatted to 385,000.00 when you leave the field.
Can I have several projects in one workbook?
Yes. Each one is its own sheet with its own settings, resources and timeline, created by running Add New Gantt Chart again.
What does Language on the dialog actually change?
It sets the language for that project’s column headings, dialogs and messages, and it is stored per chart, so two charts in one workbook can be in two different languages. You can change it at any time from the same dialog. See Working in another language.
Do I have to fill in the budgets?
No. Leave them blank and the project has no budget figure; or untick Enable Costs to switch the money side off altogether, which greys out the budget fields and leaves the budget line on the sheet empty. Both are reversible from Edit Project. Costs are covered in Work, costs & budget.

Related: The Gantt Excel tab & your chart sheet · Adding, editing & deleting tasks · Planning by the hour

From the makers of Gantt Excel Rather not work in Excel? See Desktop Plan, our project planning software for Windows and Mac