In Excel , We can find PivotTable and PivotChart options - > Under Insert tab - > PivotTable
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 :
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 ...
How to add Pivot Table ?
Consider we have sample data as shown in below image :
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:
Post a Comment