This Chart will get updated when you change any dataset values in a pivot table.You have an option to change Chart Style in excel by the click of the Styles icon on the corner of the chart.Suppose if you select only region values in the chart, it will display the total SUM of Sales for each region.

You have an option to Customize the Pivot Table Values by default, Excel uses the SUM function to calculate the values available in the table.On the corner of the chart, you have an option to format chart elements based on your choice.When you click on Region Filter Control, a search box appears with the list of all the regions, where you can check or uncheck boxes based on your choice. Now, you 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.Right, Click on the Pivot Chart, select Change Chart Type. You can name this sheet as SALES_BY_REGION, click inside the PivotTable, you can change the chart type, in Change Chart Type option, based on your choice under Analyze tab in the home, select PivotChart, insert chart popup window appears, in that Select Bar, under that select Clustered Bar chart.Then the chart looks like as given below. In the PivotTable Fields pane, select the Column fields applicable to the pivot table you can drag and drop, i.e., salesperson to the Rows section, Region to the Columns section, and sales to the Values section. PivotChart Fields task pane appears on the left side, which contains various fields, i.e., Filters, Axis (Categories), Legend (Series), and Values.Once you click OK, It inserts both PivotChart PivotTable in a new worksheet.By default, it selects table range, and it will ask you where to place a pivot table chart, here you need to always select in a new worksheet.

It will ask for the options, i.e., from a table range or from an external database. Create PivotChart dialog box appears, which is similar to the Create Pivot Table dialog box.

Here, I have selected, create both a PivotChart and PivotTable.

If you want to create a PivotChart only, then select PivotChart from the drop-down or if you want to create both a PivotChart and PivotTable, then select PivotChart PivotTable from the drop-down.

Then select the PivotChart drop-down button within the Charts group.

Then click the Insert tab within the Ribbon.

To create a Pivot Chart in Excel, select the data range.

Create excel pivot chart batch script