Forum Discussion
Abhinav2500
Nov 03, 2022Copper Contributor
gantt chart
HI I am looking for some guidance for preparing a simple gantt chart. I have a task that has to be completed twice in a year. Basically need to schedule it first and then track this over the year an...
Patrick2788
Nov 03, 2022Silver Contributor
One approach is to use a modified stacked bar chart to create a Gantt-like display. You could also use an Office template through File | New and search for "Gantt". Those templates utilize some clever conditional formatting to create the Gantt.
https://support.microsoft.com/en-us/office/present-your-data-in-a-gantt-chart-in-excel-f8910ab4-ceda-4521-8207-f0fb34d9e2b6
https://support.microsoft.com/en-us/office/present-your-data-in-a-gantt-chart-in-excel-f8910ab4-ceda-4521-8207-f0fb34d9e2b6