Join Gini von Courter for an in-depth discussion in this video Build a Gantt Chart from a stacked bar, part of Data-Driven Presentations with Excel and PowerPoint 2016.
- [Instructor] Gantt charts provide a way…to visually represent a schedule for a project for example.…They're an alternative to publishing a calendar.…And while there is no Gantt chart type in Excel,…we can create a Gantt chart with a stacked bar chart.…The reason this is a pretty cool thing to do…is that the alternative is either to purchase templates…or to use a tool like Microsoft Project to create a Gantt.…And if you're already creating your task list…in Microsoft Excel,…this is a great place to create your chart.…
You need to have three columns of data.…The list of tasks that are going to be done in order,…the starting dates for those tasks,…and the duration which has to be…in a consistent unit of measurement.…So it could be that we're going to use months…for a multi-year project…or we'll use weeks or we'll use days,…but you have to use…the same unit of measurement consistently.…One possibility is that if you select those three columns…and you choose to insert a chart…and the chart that we would want to choose…
- Identify the theme used by the default paste option.
- Recall what is embedded when you copy an Excel table and then embed the table in a PowerPoint presentation.
- Recognize the actions that may compromise data or yield incorrect results if a data table is missing descriptive labels.
- Recall the benefits of using a slicer over using a filter.
- Name a great way to illustrate the timeline and progress of a project.
- Explain what PivotTables do to tabular data.