How to use the Pivot table column labels to construct a meaningful Pivot Table.
- For updated video clips in structured Excel courses with practical example files, have a look at our MS Excel online training courses . You can even try the Free MS Excel tips and tricks course.
- To see if this video matches your skill level (see the suggested skill score below) do our free MS Excel skills assessment.
- If you are based in South Africa look at the live courses we offer in Johannesburg and Cape Town.
Pivot table column labels
Now let’s look at the Pivot table Column Labels available.
What you can see here is that the pivot table has got the months in the row labels with some amounts. It is very simple to put everything in the column labels. I grab an item, pull it across here, let go and you’ll see very quickly your pivot table has changed so the months are now in the column labels.
Everything we could do on the row labels can be done on the column labels. So, for example, if I come here and I take the day of the week, I can click it, drag it, and maybe put it after the month, let go, now we have got the month, the day of the week and the related data that relates to it. If I don’t like that, click here, maybe put it above the month, let go. Now you can see all the day 1’s- January, February, March – all the day 2’s – January, February, March etc. I am just going to go back there.
All options that were available under row labels are available under column labels. So if I right click here, you will see I can go to Field Settings and everything here is exactly the same as the row labels – so we suggest you watch the row label video clip to see how this can be useful