![]() Now that your stacked bar is up and it reflects the data you need for a Gantt chart, it’s most likely in blue and orange looking like this: Highlight the range of the tasks or task descriptions (excluding the column header).You can find this on the right-hand panel. This time, click Edit under Horizontal (Category) Axis labels.Start by launching the Select Data box (right-click on any space in the chart and click Select Data).Now that the data for the horizontal axis are all set, it’s time to add the data for the vertical axis. Similarly, highlight the range of cells under duration for the Series Values.Īt this point, the stacked bar Excel chart will start to resemble a Gantt chart.For the Series Name, click the “ Duration” cell.In the Select Data dialogue box, click Add. ![]() The next set of data that you need to add is the duration.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |