1013 Pivot Table - Pivot Chart Shortcut and Sparklines

2 minutes
Share the link to this page
You need to purchase the class to view this lesson.
One-time Purchase
List Price:  $139.99
You save:  $40
List Price:  د.إ514.19
You save:  د.إ146.92
List Price:  A$195.64
You save:  A$55.90
List Price:  ৳11,872.36
You save:  ৳3,392.34
List Price:  CA$187.43
You save:  CA$53.55
CHF 91.42
List Price:  CHF 128
You save:  CHF 36.57
List Price:  kr885.88
You save:  kr253.12
List Price:  €118.94
You save:  €33.98
List Price:  £107.33
You save:  £30.66
List Price:  HK$1,084.96
You save:  HK$310.01
List Price:  ₹10,504.31
You save:  ₹3,001.44
List Price:  RM586.20
You save:  RM167.50
List Price:  ₦53,056.21
You save:  ₦15,160
List Price:  kr1,269.01
You save:  kr362.60
List Price:  NZ$212.22
You save:  NZ$60.64
List Price:  ₱6,877.64
You save:  ₱1,965.18
List Price:  ₨23,504.32
You save:  ₨6,716
List Price:  S$192.24
You save:  S$54.93
List Price:  ฿4,370.48
You save:  ฿1,248.80
List Price:  ₺1,016.49
You save:  ₺290.44
List Price:  R2,470.71
You save:  R705.96
Already have an account? Log In


Hi there, welcome back. In this mini video I will show you how to tricks which are not immediately related to pivot table can be applied with pivot tables so that you get something very fascinating on your screen. First thing is going to be a shortcut key which helps you generate a pivot chart. So if I place my cursor on pivot table, any one cell from the pivot table grid area, and if I press F 11 function key f 11, see what is going to happen in a moment's time, it generates a pivot chart in a completely new sheet. And that pivot chart is completely customizable, as per the drop down of pivot table. So that if you choose, let's say a couple of divisions from this checkbox and press OK, the chart automatically changes based on the user inputs.

This was shortcut key number one. If I go back to the pivot table, let me make sure all of the divisions are selected. Now although I'll be talking about sparklines and much more greater detail in subsequent videos. But I want to show you that if you sparklines with the data that you have been given by the pivot table, how wonderful experience would you have, in fact, even the end user, who you are going to send this file to. So what happens is next, I go to Insert Tab, from 2010 version of Excel onwards, they have come up with something called sparklines. The section will find this under Insert Tab sparklines.

If I click on line, and what it asks me thereafter is where is your data range. So if I choose the data in somewhat like this, notice, I am not choosing the text value, nor am I choosing a grand total. And same, I'm not choosing the header I'm just choosing the numeric value. If I press OK. This is the trend which I can see based on the different divisions. Something similar.

I go to Insert, I go to win loss, loss, win loss. This is generally used when you have negative numbers. But if I go to column and then I go to these numbers and Simply choose them and press OK. There you go. This is a similar 10 but shown in bar diagram. So just integrating two shortcuts and tricks along with pivot table to give you something more

Sign Up