Creating a PivotChart in Excel in Microsoft Excel 2019

Just like normal Excel charts, a PivotChart is a graphicalrepresentation of worksheet data and/or PivotTables. PivotTables andPivotCharts are connected and so it is very important to make sure thata PivotTable is analyzed and visualized correctly to ensure that thecorrect representation flows through the PivotChart:

  1. Use the workbook from the previous topic to create a PivotChart.Click on the data on the worksheet, then go to Insert | PivotChart. Select PivotChart from the drop-down list:
ms office 173

Note that the other option allows you to create both thePivotChart and PivotTable at the same time. If you selectthe PivotTable &PivotChart option, you will simply drag fields into thedifferent areas to organize your layout and both the PivotTable andPivotChart are updated. Let’s continue to build ourPivotChart.

  1. Check that the selected range is correctly assumed by Excel andselect the option to place the PivotChart onto a new worksheet. 
  2. Click on OK to continue to buildthe PivotChart.
  1. Add fields from the left of the PivotChart Fields pane to the area on the right tocreate the PivotChart (use the following example as a guide, or tryusing your own field placements). Note that you can also add filters andslicers or insert a timeline on PivotCharts. When you click on thePivotChart, you will see that the PivotChart tool’s contextual menuappears on the title bar. Just underneath the menu are three tabs tocustomize PivotCharts—namely, Analyze,Design, and Format:
ms office 677
  1. If you update the worksheet data at any point, you will need torefresh the PivotChart. Navigate to Analyze |Refresh from the Data group todo so.

In the next section, we will look at the wonderful three-dimensionalvisual analysis feature to create stunning maps.

Leave a Comment