![]() ![]() Here are a few you can download for free: If you want to spend less time building spreadsheets, check out some of our other Excel project management templates. Add basic task details to the Excel worksheet.Apply a formula to calculate task duration.Set your Excel gantt chart at weekly intervals.Reorder tasks and move the date axis to the top.Format your stacked bar chart to look like a gantt chart.Change taskbar colors for a customized lookġ.Want to organize your Excel gantt chart into phases with subtasks? Add a row before the first task in each project phase, and enter the following dates for each task group: Add tasks and dates to the Excel worksheet for your gantt chart.Ĭreate columns for Task Name, Start Date, End Date, and Duration, and fill those cells with the basic details for your project tasks.Start Date = Start Date of your first task or milestone in the group or phase.End Date = End Date for the last task or milestone in the group or phaseĢ. ![]() Apply an automatic formula to calculate task duration Use a simple formula to subtract the start date from the end date. That way your Excel worksheet will automatically calculate the length of each task in your gantt chart. ![]() For instance, we entered =C2-B2 into the Duration field for our first task. Tip: If you started in different cells in your worksheet, be sure to adjust this formula accordingly. 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. Insert a Stacked Bar Chart from the Insert menuĬlick the Insert tab, and select the bar chart icon. Choose Stacked Bar from the 2-D Bar section to add a chart to your Excel worksheet. This chart type most closely resembles a gantt chart. You should see a blank chart in your Excel worksheet now. Right-click the chart, and choose Select Data.Ĭlick the plus sign (+) under the Legend entries section to add the first data set. Name it "Start Date." Then click on the Y values field, and select the data in the Start Date column. Repeat this process to add a second entry called “Duration,” making sure to select the data in the Duration column for the Y values. Click the Horizontal Axis Labels field, and select the entire Task Name column. Tip: Make sure the Show data in hidden rows and columns checkbox is ticked so your Excel gantt chart will still work if you decide to hide any of the columns or rows in the worksheet. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |