Create Chart for comparison from the Pivot

Advanced Excel Dashboard Crash Course Section 2: 1st Dashboard using Pivot
1 minutes
Share the link to this page
Copied
  Completed
You need to have access to the item to view this lesson.
One-time Fee
$99.99
List Price:  $139.99
You save:  $40
€88.87
List Price:  €124.43
You save:  €35.55
£75.15
List Price:  £105.22
You save:  £30.06
CA$139.41
List Price:  CA$195.18
You save:  CA$55.77
A$156.01
List Price:  A$218.42
You save:  A$62.41
S$129.82
List Price:  S$181.75
You save:  S$51.93
HK$777.79
List Price:  HK$1,088.94
You save:  HK$311.15
CHF 83.16
List Price:  CHF 116.43
You save:  CHF 33.26
NOK kr1,036.96
List Price:  NOK kr1,451.79
You save:  NOK kr414.82
DKK kr663.14
List Price:  DKK kr928.42
You save:  DKK kr265.28
NZ$169.15
List Price:  NZ$236.82
You save:  NZ$67.67
د.إ367.26
List Price:  د.إ514.18
You save:  د.إ146.91
৳12,188.92
List Price:  ৳17,064.98
You save:  ৳4,876.05
₹8,540.13
List Price:  ₹11,956.53
You save:  ₹3,416.39
RM430.10
List Price:  RM602.16
You save:  RM172.06
₦160,694.92
List Price:  ₦224,979.32
You save:  ₦64,284.40
₨28,187.10
List Price:  ₨39,463.07
You save:  ₨11,275.97
฿3,296.66
List Price:  ฿4,615.46
You save:  ฿1,318.79
₺3,876.15
List Price:  ₺5,426.76
You save:  ₺1,550.61
B$565.35
List Price:  B$791.51
You save:  B$226.16
R1,819.79
List Price:  R2,547.79
You save:  R727.99
Лв173.65
List Price:  Лв243.12
You save:  Лв69.46
₩139,574.81
List Price:  ₩195,410.33
You save:  ₩55,835.51
₪354.19
List Price:  ₪495.88
You save:  ₪141.69
₱5,536.94
List Price:  ₱7,751.94
You save:  ₱2,214.99
¥14,536.09
List Price:  ¥20,351.11
You save:  ¥5,815.01
MX$1,944.15
List Price:  MX$2,721.88
You save:  MX$777.73
QR364.06
List Price:  QR509.70
You save:  QR145.64
P1,361.73
List Price:  P1,906.48
You save:  P544.74
KSh12,933.70
List Price:  KSh18,107.70
You save:  KSh5,174
E£5,061.53
List Price:  E£7,086.34
You save:  E£2,024.81
ብር13,459.34
List Price:  ብር18,843.61
You save:  ብር5,384.27
Kz91,190.88
List Price:  Kz127,670.88
You save:  Kz36,480
CLP$93,359.66
List Price:  CLP$130,707.26
You save:  CLP$37,347.60
CN¥722.46
List Price:  CN¥1,011.47
You save:  CN¥289.01
RD$5,902.61
List Price:  RD$8,263.89
You save:  RD$2,361.28
DA13,306.79
List Price:  DA18,630.04
You save:  DA5,323.25
FJ$227.15
List Price:  FJ$318.02
You save:  FJ$90.87
Q770.30
List Price:  Q1,078.46
You save:  Q308.15
GY$20,924.33
List Price:  GY$29,294.90
You save:  GY$8,370.57
ISK kr13,059.69
List Price:  ISK kr18,284.09
You save:  ISK kr5,224.40
DH926.13
List Price:  DH1,296.62
You save:  DH370.49
L1,709.38
List Price:  L2,393.20
You save:  L683.82
ден5,476.65
List Price:  ден7,667.53
You save:  ден2,190.88
MOP$801.19
List Price:  MOP$1,121.71
You save:  MOP$320.51
N$1,867.19
List Price:  N$2,614.14
You save:  N$746.95
C$3,690.56
List Price:  C$5,166.94
You save:  C$1,476.37
रु13,561.38
List Price:  रु18,986.48
You save:  रु5,425.09
S/365.16
List Price:  S/511.24
You save:  S/146.08
K405.78
List Price:  K568.11
You save:  K162.33
SAR375.06
List Price:  SAR525.10
You save:  SAR150.03
ZK2,781.79
List Price:  ZK3,894.63
You save:  ZK1,112.83
L454.99
List Price:  L637.01
You save:  L182.01
Kč2,217.63
List Price:  Kč3,104.78
You save:  Kč887.14
Ft35,921.40
List Price:  Ft50,291.40
You save:  Ft14,370
SEK kr971.07
List Price:  SEK kr1,359.54
You save:  SEK kr388.46
ARS$112,727.26
List Price:  ARS$157,822.68
You save:  ARS$45,095.41
Bs690.65
List Price:  Bs966.94
You save:  Bs276.29
COP$424,975.26
List Price:  COP$594,982.37
You save:  COP$170,007.10
₡50,658.12
List Price:  ₡70,923.39
You save:  ₡20,265.27
L2,602.65
List Price:  L3,643.81
You save:  L1,041.16
₲803,267.16
List Price:  ₲1,124,606.16
You save:  ₲321,338.99
$U4,177.30
List Price:  $U5,848.39
You save:  $U1,671.08
zł376.14
List Price:  zł526.62
You save:  zł150.47
Already have an account? Log In

Transcript

Hello everybody, welcome back to excel dashboard. In this video we will see how to make a chart with this particular data. To do so first I'll just change the heading over here. Just keep the cursor on the heading and then you can type in the heading respectively, like average salary. Once done, press Enter to Continue from the name. Now to create a chart is fairly easy once again just by keeping the cursor inside anywhere in the data.

Press ALT f1 the shortcut key from the keyboard and the chart is ready. It's as simple as that. Another way might be to keeping the cursor in the data analyze. And if you're using 2010 or an older version in the place of analyze, it will be options pivot charts, and then select the chart that's needed. I'll be going with the stack. That's the second In one stacked column chart, and I'll click OK.

So that should do it. So here I get an overall understanding like an admin basic covers, so on and further down. So overall admin has an average salary of about 500,000, and so on. Now, once the chart is ready, we can try out other charts as well. Now this is the first pivot report that we've created for our dashboard. We will be creating two more pivots, and to create the base for the finalized report.

In the next video, we will see how to create a second pivot table directly from the first pivot table and work with that. Till then keep practicing. I'll see you in the next video. Thank you

Sign Up

Share

Share with friends, get 20% off
Invite your friends to LearnDesk learning marketplace. For each purchase they make, you get 20% off (upto $10) on your next purchase.