Microsoft Office Forums - View Single Post - Gantt Chart Help

Thread: Gantt Chart Help

View Single Post

Old

02-04-2017, 06:41 AM

xor

xor is offline

xor uses Windows 10

Windows 10 xor uses Office 2016

xor uses Office 2016

Office 2016

Expert

Join Date: Oct 2015

Posts: 1,097

xor is a name known to all

xor is a name known to all

xor is a name known to all

xor is a name known to all

xor is a name known to all

xor is a name known to all

Default

Activate the chart.
Right click and Select Data.
Choose Start and press Edit.
Change the Series Values reference as required.
OK.

Same procedure for Duration.

If you un-merge row 3 and 4, put your headings in B4:E4 and make B4:E24 an Excel Table the chart will automatically adjust in case of more tasks.

Reply With Quote