Excel

Hi Catherine

Thanks for your question about creating Gantt charts in Excel.

There are several approaches to creating the bars and timescales automatically either using conditional formatting or with a pivot table.

I've attached 3 examples here. If you are unable to access them please email info@micorsofttraining.net and ask me to forward them to you.

Gantt Project planner is a template that comes shipped with Excel 2016 and allows durations and percent progress to be included.

Gantt chart pivot shows durations and dates on a bar chart. Included a work column and a tab called Resource Work that totals the work done by resource name.

Gantt chart conditional is a sheet that colours cells by conditional formatting.

These examples may not be suitable for large projects where it might be better to use software such as MS Project.

I hope that helps for now.

Regards
Doug Dunn
STL