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.

Excel pivot chart date axis continuous