![]() ![]() Click the icon next to the “Series values” field to open a new “Edit series” window. ![]() Name your series by typing in the name (i.e., “Duration”) or placing your cursor in the name field and clicking on the column header in the spreadsheet.Click the “Add” button under “Legend entries (series),” and an “Edit series” window will open.A “Select data source” window will open, with “Start date” already listed as a series.Right-click on the chart, and select “Select data” from the menu.The next step is to add another series to your Excel chart to reflect each task’s duration. The bar chart will visualize your Gantt chart’s most important data points Step 3: Input Duration Data Or, if you have a hard deadline for a task and know how long it takes to complete, you can enter the End date and Duration and find the necessary Start date with this formula: ![]() You can manually enter the duration of the task or use one of these Excel formulas to fill in those cells automatically:įor example, if Start date is column B, End date is column C and Duration is column D, then the formula in cell D2 would be C2-B2 or C2-B2+1.Īlternatively, you can find the End date by entering the Start date and the Duration and using this formula:
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |