Drag the edge of a task: its duration changes. Slide it: its date changes. Either way, everything that depends on it re-plans itself — skipping weekends, public holidays and leave. All inside Excel, with no subscription and no server.
The demonstration below replays exactly how the add-in behaves. Same ribbon, same gestures, same date engine. Play with it freely.
Tip: hold Ctrl to select two non-adjacent rows, then click Link / Chain.
You know the three-column table that gets recoloured by hand every Monday. Here is what changes when the bars become real objects.
A macro-enabled Excel workbook, a dedicated ribbon, and nothing else to install.
Right edge = duration. Left edge = start date, end date frozen. Body = whole shift. A summary bar moves its entire package in a single gesture.
Links finish→start, start→start, finish→finish, with lag. Select several rows and chain them in one click. Circular dependencies are refused.
Configurable working days of the week, French public holidays calculated (Easter included), and your leave excluded from the schedule.
Every task shows its float in days. Zero float = any delay on it pushes the end of the project. One button, and the critical chain appears.
Indent, outdent, move up, move down. The numbering 1.2.3 recalculates itself, and the links never break.
An undo stack of the schedule's own, wired to Ctrl+Z. No gesture is final.
Under thirty seconds each. Sound is not needed.
The right edge is dragged out by two days: the four following tasks move back by the same amount, without touching the keyboard.
Three rows selected, one click on “Link / Chain”: they line up end to end, weekend skipped.
Critical path shown: the tasks with no float appear, and you finally know which one is holding the end date.
Would you rather try it yourself? The demonstration is just above.
No subscription, no account to create, no data going anywhere else.
The complete workbook, ready to use.
Secure payment · Refunded for 30 days · Invoice provided
Windows + Excel 2016 or newer
Our guide explains how to draw a Gantt chart in Excel with two formulas and conditional formatting: working days, French public holidays, a today line and overruns in red. Every formula in it has been tested.
Read the guide “Making a Gantt chart in Excel” →No. It is an Excel workbook: you open it, you enable macros, and the GANTT tab appears. No server, no database, no account.
No, and we would rather say so plainly: the custom ribbon and the handling of shapes require Excel on Windows (2016 or newer). On a Mac or in the browser the file opens, but the gestures do not work.
Picking up moved blocks relies on one check per second, active only on the schedule sheet. Measured on 200 tasks: 0.09% of one core. And if you would rather no check ran at all, an “Auto-track” switch turns it off: a button then validates your moves whenever you decide.
200 rows per schedule, organised into work packages and subtasks. Beyond that, better to split across several workbooks — it is more readable too.
Yes. The VBA is open and commented throughout. You can add your own columns, change the colours, wire in your own macros.
Refunded within 30 days, no justification needed. Simply write to contact@outilsexcel.fr.