You’ll now have an Excel bar chart that lists your tasks and dates-in reverse order. Click OK on the “Axis labels” window and the “Select data source” window to add this information to your chart.Alternatively, you can fill in the “Axis labels” field with this formula: =’’!$$:$$. With this window open, select the cells in your Start date column, excluding the header and any empty cells.Select “Start date” in the left “Series” list, and click “Edit” on the right “Category” list.Right-click on the chart to open the “Select data source” window.You’ll open the “Select data source” window again to get your chart to reflect the task names, instead of row numbers along the left side. When you enter your duration data into the table, your Gantt chart will serve as a quick and easy way to track your project. Click OK to add the series to your chart. You’ll again see the “Data source” window, now with “Duration” added as a series.Once the “Series name” and “Series values” fields are filled in, click OK to close the window.Alternatively, you can fill in the “Series values” field with this formula: =’’!$$:$$.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |