For example, when we click on the “Region” filter control, a search box appears with the list of all the regions, where we can check or uncheck boxes based on the choice. Now, we can summarize the data with the help of interactive controls present across the chart.Under “Change Chart Type,” select “Column.” Then, select the “Clustered Column” Chart.Then, right-click on the PivotChart, and choose “Change Chart Type.” Under that, select the “Bar” and “Clustered” bar chart.

Select “PivotChart, and” the “Insert Chart” popup window appears. Then, we can change the chart type in the “Change Chart Type” option based on choice under the “Insert” tab. We can name this sheet “SALES_BY_REGION” by clicking on the PivotTable.Then, we can drag and drop, i.e., “Sales_person” to the “Rows” section, “Region” to the “Columns” section, and “Sales” to the “Values” section. Next, in the PivotTable Fields pane, select the “Column” fields applicable to the Pivot Table. “PivotChart Fields” task pane appears on the left, containing various fields: Filters, Axis (Categories), Legend (Series), and Values.

Clicking “OK” will insert PivotChart and PivotTable into a new worksheet.

Here, we always need to choose a new worksheet. By default, it selects “Table/Range,” which will ask where to place a PivotTable chart. It will ask for the options: Table/Range or Use an external data source. Then, make PivotChart, a dialog box appears, similar to the “Create PivotTable” dialog box.

Here, we have selected and created both a PivotChart and PivotTable.

So, for example, if we want only to create a PivotChart, choose “PivotChart” from the dropdown or if we are going to make both a PivotChart and PivotTable, then select “PivotChart & PivotTable” from the dropdown.

Then, select the “PivotChart” dropdown button within the “Charts” group.

Then, click the “Insert” tab within the ribbon.

We must first select the data range to create a PivotChart in Excel.

Pivot charts mac excel 2013