0331 Insert World Map into the chart

Advanced Excel Dashboard Crash Course Section 3: 2nd Dashboard using Functions
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
€87.32
List Price:  €122.26
You save:  €34.93
£75.47
List Price:  £105.67
You save:  £30.19
CA$136.98
List Price:  CA$191.78
You save:  CA$54.79
A$142.34
List Price:  A$199.28
You save:  A$56.94
S$128.05
List Price:  S$179.28
You save:  S$51.22
HK$783.01
List Price:  HK$1,096.25
You save:  HK$313.23
CHF 78.92
List Price:  CHF 110.49
You save:  CHF 31.57
NOK kr972.40
List Price:  NOK kr1,361.40
You save:  NOK kr388.99
DKK kr652.50
List Price:  DKK kr913.53
You save:  DKK kr261.02
NZ$171.72
List Price:  NZ$240.41
You save:  NZ$68.69
د.إ367.21
List Price:  د.إ514.11
You save:  د.إ146.90
৳12,290.24
List Price:  ৳17,206.83
You save:  ৳4,916.58
₹9,241.07
List Price:  ₹12,937.87
You save:  ₹3,696.79
RM393.01
List Price:  RM550.23
You save:  RM157.22
₦138,727.12
List Price:  ₦194,223.52
You save:  ₦55,496.40
₨27,966.28
List Price:  ₨39,153.92
You save:  ₨11,187.63
฿3,252.42
List Price:  ฿4,553.52
You save:  ฿1,301.10
₺4,418.64
List Price:  ₺6,186.28
You save:  ₺1,767.63
B$536.66
List Price:  B$751.35
You save:  B$214.68
R1,687.69
List Price:  R2,362.84
You save:  R675.14
Лв170.79
List Price:  Лв239.11
You save:  Лв68.32
₩149,589.97
List Price:  ₩209,431.95
You save:  ₩59,841.97
₪313.61
List Price:  ₪439.07
You save:  ₪125.45
₱5,979.30
List Price:  ₱8,371.26
You save:  ₱2,391.96
¥15,930.69
List Price:  ¥22,303.61
You save:  ¥6,372.91
MX$1,784
List Price:  MX$2,497.67
You save:  MX$713.67
QR364.08
List Price:  QR509.73
You save:  QR145.65
P1,364.83
List Price:  P1,910.81
You save:  P545.98
KSh12,926.70
List Price:  KSh18,097.90
You save:  KSh5,171.20
E£5,242.14
List Price:  E£7,339.21
You save:  E£2,097.06
ብር15,634.10
List Price:  ብር21,888.37
You save:  ብር6,254.26
Kz91,203.97
List Price:  Kz127,689.21
You save:  Kz36,485.24
CLP$92,059.79
List Price:  CLP$128,887.39
You save:  CLP$36,827.60
CN¥689.55
List Price:  CN¥965.39
You save:  CN¥275.84
RD$6,153.44
List Price:  RD$8,615.06
You save:  RD$2,461.62
DA13,248.79
List Price:  DA18,548.83
You save:  DA5,300.04
FJ$222
List Price:  FJ$310.81
You save:  FJ$88.81
Q768.08
List Price:  Q1,075.35
You save:  Q307.26
GY$20,954.45
List Price:  GY$29,337.08
You save:  GY$8,382.62
ISK kr12,593.74
List Price:  ISK kr17,631.74
You save:  ISK kr5,038
DH943.33
List Price:  DH1,320.70
You save:  DH377.37
L1,751.14
List Price:  L2,451.67
You save:  L700.52
ден5,384.61
List Price:  ден7,538.68
You save:  ден2,154.06
MOP$807.41
List Price:  MOP$1,130.41
You save:  MOP$322.99
N$1,682.21
List Price:  N$2,355.16
You save:  N$672.95
C$3,685.43
List Price:  C$5,159.74
You save:  C$1,474.31
रु14,792.28
List Price:  रु20,709.79
You save:  रु5,917.50
S/345.39
List Price:  S/483.57
You save:  S/138.17
K437.97
List Price:  K613.17
You save:  K175.20
SAR375.21
List Price:  SAR525.31
You save:  SAR150.10
ZK1,949.51
List Price:  ZK2,729.39
You save:  ZK779.88
L444.85
List Price:  L622.81
You save:  L177.96
Kč2,134.15
List Price:  Kč2,987.89
You save:  Kč853.74
Ft34,201.59
List Price:  Ft47,883.60
You save:  Ft13,682
SEK kr940.84
List Price:  SEK kr1,317.21
You save:  SEK kr376.37
ARS$139,811.02
List Price:  ARS$195,741.03
You save:  ARS$55,930
Bs692.10
List Price:  Bs968.97
You save:  Bs276.87
COP$368,746.35
List Price:  COP$516,259.64
You save:  COP$147,513.29
₡47,124.61
List Price:  ₡65,976.34
You save:  ₡18,851.73
L2,651.23
List Price:  L3,711.84
You save:  L1,060.60
₲646,170.79
List Price:  ₲904,664.96
You save:  ₲258,494.16
$U4,038.16
List Price:  $U5,653.59
You save:  $U1,615.42
zł372.86
List Price:  zł522.01
You save:  zł149.15
Already have an account? Log In

Transcript

Hello, everybody, welcome to the second dashboard. In this video we will see how to assign markers to a map. So let's see which chart we can use to create a map for creating a map, we'll go to Insert, then scatter chart. And here we will use the first one. So Once selected, it is this scatter chart, we have it ready, and we'll just position it where we want it. So that should do it for me.

So just increase the height a little bit, just for a better view. And there we have it. Now, to put the map into the scatter chart, we'll first we'll go to the internet and we'll find a particular link. And we'll just copy that into any kind of software that allows you to copy the image. I've used snippet to select the frame. Copy it, so just let it be on the clipboard and now how to get the image from the clipboard into the chart.

That's what I'm going to show you. So just right click on the chart and select chart, format chart area where you can get a paint bucket and then you can actually select a blank with no fill, they would be transparent, but we want the one that has pictures or texts. So just click on the current which by default, shows a pattern. Here we have an option that says from clipboard, just click on clipboard, and there it is. Now the map is placed into the screen. Now if we need to do any modification, we can do it over here by cutting, cropping or we can edit it in Photoshop or maybe another application used for editing.

Once done, just close this panel and there it is, a map is ready for the chart. And once we have this done, we just have to plot the data which we'll be seeing in the next video. Till then keep practicing. 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.