gantt charts excel

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

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

Gantt charts in Excel 2016

resolvedResolved · Urgent Priority · Version 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:

Using the Quick Access Toolbar in Project 2010

The Quick Access Toolbar is included in virtually every Office product, including Project 2010 as well as Outlook 2010, Word 2010, Excel 2010, and PowerPoint 2010.

You will find the Quick Access Toolbar in the top-left side of the window. To begin, click the Customize button (it's the little black arrow at the end of the toolbar).

Simply click the commands you want to include.

Virtually any command can be added to the Quick Access Toolbar. Click the More Commands option and a new window will open from where you can browse the commands including those not on the ribbon.

View all MS Project hints and tips


Server loaded in 0.09 secs.