Excel - How to add Pivot Table and chart

In Excel , We can find PivotTable  and PivotChart options - > Under Insert tab - > PivotTable


How to add Pivot Table ?




Consider we have sample data as shown in below image :

  
 
Click on any cell where you want to add Pivot table and then goto Insert tab - > PivotTable 








Drag & drop Columns from PivotTable Field List to Column Labels , Row Labels and Summation Values :



How to add Pivot Chart ?


In the similar way did for Pivot table , Click on any cell where you want to add Pivot chart and then goto Insert tab - > PivotChart




Drag & drop Columns from PivotTable Field List to Legend Fields , Axis Fields and Summation Values :




You can also change the Chart type by clicking inside the chart - > right-click - > 
Change Chart Type ...





No comments: