Macro Gantt Chart

Resolved · Low Priority · Version 2016

Tue 23 Jul 2019, 15:55 Delegate Daniel said...

Daniel has attended:
Excel Advanced course

Macro Gantt Chart

Hello,

I want to build a Gantt chart to show a project timeline. However, I want to make it available for the rest of the team to add tasks etc. Does anyone know how:

1) I am able to get the Gantt add in like I can see in some of the example charts I have seen?
2) How to create a 'form' people can fill out that then auto populates into the Gantt chart?
3) Any advice on a macro Gantt chart?

Thanks very much,
Dan

Tue 23 Jul 2019, 21:43 Trainer Jens said...

RE: Macro Gantt Chart

Hi Daniel,

Thank you for the forum question.

Excel can do everything (almost).

I do not know which add in you use, but you can create a gantt chart without a add in (please see link below)

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

The input form can be done with VBA only. Macros cannot create forms. It is complicated and you need VBA knowledge. We are creating userforms on our VBA intermediate course.

I have found a video which can make you get started.

https://www.youtube.com/watch?v=5PN7lWJSobQ

Kind regards

Jens Bonde
Microsoft Office Specialist Trainer

Tel: 0207 987 3777
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

Tue 30 Jul 2019: Automatically marked as resolved.

Training courses

	98.8 % recommend us
	More live stats...

Training information:

Excel tip:

No Zeros

Want all the zeros in your worksheet to appear blank? Choose Tools/Options, Click on the View Tab, Deselect the Zero Values Option, Click OK.
Easy wasn't it? But be aware that these cells are not actually blank, they still contain the value zero. This is important because certain functions (ie AVERAGE) make a distinction between blank cells and those with a zero value.

View all Excel hints and tips