If Excel doesn’t support automatically making Gantt charts, why would you want to make one?
For one specific reason: because it’s the best way to show project timelines.
Whether you’re planning a project and showing estimated time commitments or reviewing a project and showing what actually happened, a Gantt chart makes your information clearer than any other graph.
Scheduling, task assignment, and other project-management-related concepts are all well-represented by a Gantt chart.
But because creating on is rather involved, if you’re considering using a Gantt chart for anything else, make absolutely sure there isn’t a better graph for your purpose.
A line graph is great for showing fluctuating values over time, for example. And a column chart is good for comparing sets of values.
If there’s another chart that will serve your purpose, we recommend using it, as creating a Gantt chart is a bit involved.