Right-click the chart, and choose Select Data.Ĭlick the plus sign (+) under the Legend entries section to add the first data set. You should see a blank chart in your Excel worksheet now.
This chart type most closely resembles a gantt chart. Choose Stacked Bar from the 2-D Bar section to add a chart to your Excel worksheet. Insert a Stacked Bar Chart from the Insert menuĬlick the Insert tab, and select the bar chart icon. Place your mouse on the right corner of D2 until you see a black + sign and double-click or drag your mouse down to paste the formula in the remaining cells in column D. Tip: If you started in different cells in your worksheet, be sure to adjust this formula accordingly. For instance, we entered =C2-B2 into the Duration field for our first task. That way your Excel worksheet will automatically calculate the length of each task in your gantt chart. Use a simple formula to subtract the start date from the end date. Apply an automatic formula to calculate task duration
Our easy premade Excel gantt chart template can save you tons of time by organizing your project plan and tackling the tedious scheduling work for you! Use this Excel gantt chart to simplify complex projects into an easy-to-follow plan and track the status of tasks as work progresses. Create an easy Excel gantt chart with our free template