Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

gantt charts excel

Forum home » Delegate support and help forum » Microsoft Project Training and help » Gantt charts in Excel 2016

Gantt charts in Excel 2016

ResolvedVersion 2016

Gantt charts in Excel 2016

Hi,
I am creating Gantt chars for multiple projects, and would like to show the data on a 'master' Gantt chart. Can anybody advise how to do this please?
Thanks.

RE: Gantt charts in Excel 2016

Hi Mitch,

Thank you for the forum question.

There is a very good step by step tutorial if you click on the link below. I have also attached an example with multiple projects in one Gantt chart.

Please find attached workbook.



https://www.ablebits.com/office-addins-blog/2014/05/23/make-gantt-chart-excel/




Kind regards

Jens Bonde
Microsoft Office Specialist Trainer

Tel: 0207 987 3777
Best STL - https://www.stl-training.co.uk
98%+ recommend us

London's leader with UK wide delivery in Microsoft Office training and management training to global brands, FTSE 100, SME's and the public sector

Attached files...

gantt.xlsx

RE: Gantt charts in Excel 2016

Try this website for all your PM solutions

And download Gantt chart template in Excel 2016 -
http://www.techno-pm.com/2016/06/gantt-chart-excel-template-free-download.html

Mon 31 Oct 2016: Automatically marked as resolved.

MS Project tip:

Enter a Date

You can enter today's date (or tomorrow's date) in a date field, by simply typing in the word 'today'or 'tomorrow' and Project will insert the date for you.

View all MS Project hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 0.1 secs.