Creating a Power Pivot Chart in Excel

Last Updated : 12 Jan, 2023

Power Pivot is an Excel add-in that is available for Excel 2021, Excel 2019, Excel 2016, and Excel 2013. Power Pivot is used to create data models and performs high-level data analysis to establish relationships and give results easily. Power pivot can analyze large data rapidly and creates data models by building extensive relationships and calculations based on the given data.

Creation of Power Pivot Chart

Let’s create a chart using Power Pivot on the following data model.

Step 1: Click the Home tab, which is visible above, and click on the pivot table

Step 2: Then click on the pivot chart.

Then a dialog box appears. Select a new worksheet and click ok. Then it will appear like the image below, which contains all the table names in pivot chart fields.

Step 3: Then click on the pivot chart fields (which contain table values) that represent the chart.

So by clicking these fields, the chart will appear according to their relation.

These are called value field buttons. Based on the data in these field buttons, the chart is prepared.

This is called a Legend. In this area sum of values is given. We can remove the legend and value field buttons. The icon at the left side bottom(which is named ‘Name’) is called Axis filed button.

Click on the + icon that appears right side of the chart then you can see the chart elements. Untick the boxes if you want them to hide.

You can change the style and color of the chart from this option.

Fields list

The power pivot chart contains two tabs, Active and All.
Active tabs consist of data tables that are added to the power pivot chart.
All tabs consist of all the data tables in the data model.

Filters

By clicking the axis field button, a drop-down menu will appear. We can hide or unhide the values as we wish. There is also another method, and we can drag the field to the filter area for filtering the values and search for the chosen report values. Then choose the values you want to hide.