Join Gini von Courter for an in-depth discussion in this video Create a PivotChart, part of Data-Driven Presentations with Excel and PowerPoint 2016.
- [Instructor] We know how to create Pivot Tables…and we know how to create charts,…therefore it's easy to create Pivot Charts.…Simply select the table for which…you wish to create a Pivot Chart.…Go to our Pivot Table Tools.…And on the Analyze tab, in the Tool section,…you'll find Pivot Chart.…Click the Pivot Chart button, and you'll see choices…for how we might want to present the information.…I like this stacked column chart that shows us…the number of orders, it has some good information.…Let's choose that chart.…
Number of orders.…There are the months.…These are filter buttons.…So I can filter by region.…I can filter by month, that's pretty slick.…And if I modify the table, if for example, I,…decide that I'd like to filter it,…so let's show our Field Headers again.…And I want to filter, so it does not include Europe.…Notice that when I do this,…it automatically changes the chart.…
The chart is a visualization based on this table.…That means if I want multiple charts that are different,…I will need to have multiple Pivot Tables.…
- 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.