![]() Click “Close” to close the window and update your chart.Under “Axis options,” select “Categories in reverse order.”.Click the list of tasks on the left side of the chart to select them and open a “Format axis” window.Under “Border color,” select “No line.”.With all the bars selected, right-click and select “Format data series” from the menu to open a “Format data series” window.Click any bar in the chart, and you’ll select all of them.To turn your Excel stacked bar chart into a visual Gantt chart, you need a few tweaks.įirst, remove the portion of each bar representing the Start date, and leave just the portion representing the task duration. (Don’t worry we’ll fix that in a minute.) Step 5: Transform Into a Gantt Chart 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.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |