PivotChart is a tool which is usually used for creating dashboard or viewing the report in smooth way by just changing few options in PivotTable. Basically PivotChart creates dynamic chart based on PivotTable data. Yes it is dynamic because while you changed the settings of PivotTable the data has changed and then based on this data PivotChart also changed instantly. PivotChart added a PivotTable automatically so that, you don't need to create a PivotTable additionally. How to create a PivotChart? Step 1: Place the raw data in your worksheet: Image 1: Raw data Step 2: Now for creating the PivotChart based on this raw data Click the Insert menu and then Select the PivotChart from PivotChart. Image 2: Select PivotChart from PivotChart Step 3: After selecting the PivotChart, a dialog box will appear named: Create PivotChart. In this dialog box, you have to select two things. First is the data table by which the PivotChart will work and second is the location of PivotChart...