Learn how to make and work with Excel pivot tables in this video tutorial from Microsoft. Sometimes it's hard to see the big picture when your raw data hasn’t been summarized. Your first instinct may be to create a PivotTable, but not everyone can look at numbers in a table and quickly see what's going on. PivotCharts are a great way to add data visualizations to your data.

In this video tutorial, you will learn how to create a PivotChart in Excel to better present and visualize your raw data.

1. Select a cell in your table

2. Select Insert and then PivotChart

3. Select where you want the PivotChart to appear

4. Select OK.

5. Select the fields to display in the menu