A PivotTable is an interactive table that contains fields, which are used to summarize and analyze based on several criteria for grouping, represented as a crosstab which facilitates the interpretation of such data. It is dynamic because it allows us to obtain different total, filtering data, changing the presentation of data, displaying or not the data source, etc. The pivot table can be updated as data are updated in the source table. From this table we can create a dynamic graphic which like the dynamic tabal relates PivotTable data itself, ie if data is changed on either side of the graph also changes. Without further ado let's see how to create a PivotTable:
- To start with, we have a simple table like this (obviously you can get more data):
- Next step is to select the table CTTRL + E (or simply leave the cursor within the table) and go to Insert and choose PivotTable (note that we can also choose to create a dynamic chart, but are we going to do next) :
- Done this we will get a window where we see that all the source table has been selected, this window can be given the option to place the PivotTable in the current worksheet or else we can put in a new one:
- done this, you will create a new spreadsheet as shown:
- Now we just have to add a check to the headers you want displayed in the PivotTable, and see how it will creating the table:
- can use the options tab of the PivotTable to perform multiple options such as creating a PivotChart, for this we click the PivotTable and automatically get the option at the top:
- PivotChart We click and automatically create our PivotChart (choose the type of chart you want to use):
- And we will have our dynamic graph, which can be updated by moving the data source and then update:
- can use chart tab and the tab presentation to give a better presentation to our chart:
- can guide us better with this video:
FOR EXCEL 2007
FOR EXCEL 2003
0 comments:
Post a Comment