Designing a Dynamic Gantt Chart in Excel
Instruction: Describe a Gantt timeline that updates when task start or end dates change. Use calendar days and explain how added tasks and dates enter the formatting range.
Context: Use a worksheet grid with task name, start date, inclusive end date and daily date columns. Do not assume dependencies or business-day calendars are computed automatically.
Updated
Official answer available
Read the opening below, then unlock the full answer and practical guidance.
A conditional-formatting grid is one straightforward Gantt implementation for calendar-day tasks.
Put task names in column A, real Excel start dates in B and inclusive end dates in C. Require end date to be on or after start date. Put real daily dates across row 1 from D1 onward...