How to use the Pivot table column labels to construct a meaningful Pivot Table
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
Advanced Excel Course – June 2013 in South Africa Our next advanced excel course is running during June 2013 in Johannesburg. During the week of the 10th June we offer the following options. You can either attend the full 5 … Continue reading
A very popular chart is the waterfall chart which shows the impact of various items on a total e.g. the various components that explain the move from budgeted profit to actual profit. A common way to build this is using … Continue reading
Just a quick note to say your blog is brilliant. Full of useful bits of info. After your courses, I am by far the best modeller in our office, and we regularly get comments from our business partners on the quality of our models. Thanks for all the help,– Mike