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.
To create a Pivot Chart in Excel, select the data range.
0 kommentar(er)
