Pivot Table and Pivot Chart

Pivot table is a function, which will help in doing some pictorial representation and more clarity on the data available in Excel.


Thought of sharing this knowledge about how to use the Pivot table in Excel.


To share this knowledge, I would take a scenario, where in, it talks about Travel from source to destination and also about the fare, duration of journey and also the mode of transport. We have the data already in the excel as below.

Source	Destination	Mode	Start	End	Fare	Duration	Passengers
Bangalore	Delhi	Train	10:00 AM	9:50 AM	1000	23.5hrs	5
Bangalore	Delhi	Bus	11:00 AM	9:00 AM	2000	22hrs	10
Bangalore	Delhi	AirBus	12:00 PM	2:00 PM	7000	2hrs	5
Mumbai	Delhi	Train	10:00 AM	9:50 AM	1000	23.5hrs	10
Mumbai	Delhi	Bus	11:00 AM	9:00 AM	2000	22hrs	5
Mumbai	Delhi	AirBus	12:00 PM	2:00 PM	7000	2hrs	10
Bangalore	Mumbai	Train	10:00 AM	9:50 AM	1000	23.5hrs	5
Bangalore	Mumbai	Bus	11:00 AM	9:00 AM	2000	22hrs	10
Bangalore	Mumbai	AirBus	12:00 PM	2:00 PM	7000	2hrs	5

For this kind of data, we can use the pivot table or pivot chart. For this we need to follow the things mentioned below:


Step 1:


For the data that you want to check in the excel for the Pivot information, we need to first, select the desired data as shown above.

Step 2: 


Now click on Insert from the Excel Menu, where you will be finding the Pivot table as shown below. Click on either Pivot Table or Pivot Chart.

If you are clicking on Pivot Table, then you will see the Create Pivot Table window, click on OK, and this will re-direct to a different sheet with in the book, and this will have the look as below.

If you are clicking on Pivot Chart, then you will see the Create Pivot Chart window, click on OK, and this will re-direct to a different sheet with in the book, and this will have the look as below.

Step 3: 


In Pivot Table
Now that if you select the check boxes available in the Pivot table Field List, you will be able to see the data 
as below:

In Pivot Chart

In the above pics, highlighted in bold red color are having fields that can be dragged and dropped where required among Report Filter / Column Labels / Row Labels / Values.


Hope this post, gives some basic information about how to use the pivot table in Excel.








Date Changes, Month Changes, Year Changes, Be Yourself, No Matter What ever Changes......!