How to organize your data to easily create a consistent pivot chart
The easiest way to organize your data if you want to use the powerful tool of pivot chart in Excel is to work by columns with titles on first row, such as the example below:
Example: Planning / tracking of an entertainment company. The company tracks the number of ticket sold depending of the type of event (show / concert), the location of the event (main stage / second stage) and by date.
1) Organization of data base
Instead of presenting the database like this for example:
Pick up the different variables of the spreadsheet (type of event, location, number of ticket sold, date) and organize the database by columns, with the titles of the different variables in first row:
2) Pivot chart creation
Simply select the entire table and click on "Pivot Chart" (Menu "Insert").
Then locate the cell you want the pivot table to be created (Note that a pivot chart is always based on a pivot table).
3) Set up of the pivot chart
Example 1: Display the sum of tickets sold by type of event:
Example 2: Display the sum of tickets sold by stage and by type of event:
No comments:
Post a Comment