Building a Free Gantt Chart Maker with AI

For a long time, I struggled to create Gantt charts in Excel. Despite spending hours configuring cells, formatting dates and wrestling with conditional logic, the results were always rigid and difficult to maintain. Every small change to a timeline meant redoing the entire setup.

To escape the Excel nightmare, I started relying on a paid online tool. It was better, but it had a significant limitation: the free tier only allowed a few entries before locking features or demanding an upgrade. I was constantly hitting artificial limits just trying to do basic project planning.

That's when I realised I could solve this myself. With the help of AI, I built my own tool that does exactly what I need, without those limits. The result is Cheeky Gantt, a free Gantt chart maker that turns Excel data into a timeline you can export to PowerPoint.

What I needed from a Gantt chart tool

The requirements came straight from the frustrations above:

• Start from the spreadsheet I already have. Project plans usually live in Excel, so I wanted to paste the data in rather than retype it.
• No limits on tasks. A real project has dozens of tasks, and a tool that stops at a handful isn't useful.
• Output that works in presentations. Most Gantt charts end up in a slide deck, so the export needed to be editable in PowerPoint, not just a flat picture.
• No accounts, and private by default. Project plans can be confidential, so the data should stay on my machine.

Why AI made it practical

A tool like this used to mean weeks of development. Working with AI changed that. I could describe what I wanted, such as parsing pasted spreadsheet rows, drawing the timeline, and exporting shapes to PowerPoint, then test the result and refine it step by step. Instead of adapting my work to someone else's tool and pricing, I could build around my own workflow.

It's a good example of a wider shift: recurring, specific frustrations that were never worth a full software project are now worth solving yourself.

What Cheeky Gantt does

• Paste from Excel: copy your task rows and paste them straight in.
• Add tasks manually: if you don't have a spreadsheet, build the chart one item at a time.
• Different item types: bars for tasks, plus milestones, flags and section headers to structure the plan.
• Colours: built-in colour schemes for the whole chart, or a custom colour on any individual item.
• Timeline views: zoom by day, week or month, and shade weekends.
• Export: download an editable PowerPoint slide, a PNG image, or copy the chart to your clipboard.
• Saving: your chart is saved automatically in your browser, and you can save a project file to back it up or move it to another computer.
• Private: everything runs in your browser, and your tasks are never uploaded to a server.

It's free and needs no sign-up.

How to make a Gantt chart from Excel data

1. Arrange your columns. In Excel, order the columns as Task Name, Start Date, End Date and, optionally, Type. Use DD/MM/YYYY dates.
2. Copy the rows. Select the task rows and copy them. Excel separates the columns with tabs, which is the format the tool expects.
3. Paste into Cheeky Gantt. Open Cheeky Gantt, paste into the Excel data box, and add the tasks. If you want to see the format first, try the sample data.
4. Structure the plan. Add section headers for phases, and milestones for key dates such as launches, approvals or deadlines.
5. Style it. Choose a colour scheme, and highlight critical tasks with a custom colour.
6. Export. Choose PowerPoint for an editable slide, or PNG for documents and emails.

Tips for a clearer project timeline

• Group tasks into phases. Section headers such as "Discovery", "Build" and "Launch" make a long plan easy to scan.
• Keep task names short. Long names crowd the chart. Put the detail in your project notes.
• Use milestones for decisions and deadlines, not for ordinary work. If everything is a milestone, nothing stands out.
• Use colour sparingly. One highlight colour for critical or at-risk items is more readable than a rainbow.
• Match the zoom to the audience. Week or month views suit steering groups; day view suits the delivery team.
• Present one timeline per slide. If the plan is too long, split it by phase rather than shrinking the text.

Try it

Building Cheeky Gantt turned a recurring frustration into a permanent, custom-built solution in a matter of hours. If you've been fighting Excel timelines or running into limits on paid tools, give Cheeky Gantt a try. Paste your plan in and see the difference.