9:11 AM
Excel Pivot Charts
Working with Pivot Tables and Pivot Charts
What do mean by Pivot Table?
What do mean by Pivot Table?
Pivot tables are one of Excel's most powerful features. A pivot table allows you to extract the significance from a large, detailed data set. Our data set consists of 214 rows and 6 fields. Order ID, Product, Category, Amount, Date and Country.
Example for Pivot Table
01.Design Sample Excel Data Table as Follows
02.To add PIVOT Table Select the entire Table then under the Insert Tab Select Pivot Table as shown in the screen shot.
03.Then following dialog box will appear there you have to click Ok
04.Then Select Fields to Create Pivot Table.Once you Selected drag those fields to relevant areas as shown in the following screen shot.
05.To Insert a Pivot Chart simply insert Chart by clicking any cell inside the pivot table.then you can get a chart like this.
