Selecting Chart Source Data using Data Validation Dropdown

Data Validation Dropdown

Zimbabwe Zimbabwe
25

20

15

10

0
2011 2011 2011 2011 2011 2011
Jun Jul Aug Sep Oct Nov

Selected Row 140

Column Number 1 2 3 4 5 6

2011 2011 2011 2011 2011 2011

Date Jun Jul Aug Sep Oct Nov

Zimbabwe 10 12 13 14 15 16

Source: Google Analytics for www.launchexcel.com

Sum of Pageviews 2011 2011 2011 2011 2011 2011
Country Jun Jul Aug Sep Oct Nov
Albania 1
Algeria
Angola 1
Argentina 4 2
Armenia
Aruba
Australia 1 3 13 6 31 30
Austria 2 2
Azerbaijan
Bahrain 2 1
Bangladesh
Barbados 3
Belarus
Belgium 2 6
Belize
Benin
Bhutan
Bosnia and Herzegovina
Botswana
Brazil 3 2
Brunei
Bulgaria 2
Cambodia 1
Cameroon 1
Canada 11 1 5 15 41 57
Chile 2
China 1 2 11 3
Colombia 8
Costa Rica
Croatia 3
Cyprus 1
Czech Republic 1
Denmark 3 1 3
Dominica 1
Dominican Republic
Ecuador
Egypt 1 2
El Salvador 6
Estonia 1
Ethiopia
Finland 1 21
France 2 1 6 20
Georgia
Germany 1 6 2 5 24
Ghana
Greece 2 4 2
Guam 1
Guatemala 1
Honduras
Hong Kong 9 2 19
Hungary 2 2
Iceland
India 14 7 21 62 85 111
Indonesia 3 2 1 7
Iran 1 1
Iraq
Ireland 9 3 6 3
Israel 14 7 20
Italy 1 3 3
Jamaica 2
Japan 2 6
Jersey
Jordan 52
Kazakhstan 2
Kenya 1
Kuwait 5
Laos
Latvia
Lebanon 1
Libya
Lithuania
Luxembourg
Macau
Macedonia [FYROM]
Malawi
Malaysia 1 1 6
Maldives
Malta
Mauritius
Mexico 4 1 1 1
Mongolia 1
Montenegro
Morocco 6
Myanmar [Burma]
Namibia
Nepal 1
Netherlands 1 5 34 9
Netherlands Antilles
New Zealand 3 7
Nigeria 1
Norway 1
Oman 2
Pakistan 1 6 22
Palestinian Territories 1
Papua New Guinea 1
Paraguay
Peru
Philippines 1 2 6 10 24
Poland 1 1 6
Portugal 1 1 2
Puerto Rico
Qatar 3 5 1
Romania 2 6 7
Russia 4 6 1
Saudi Arabia 2 8 4
Senegal
Serbia 1 23
Singapore 16 7 22 6
Slovakia
Slovenia 1 11
Solomon Islands
South Africa 3 10 11
South Korea 2 2
Spain 4 5 12
Sri Lanka 1 1
Sudan
Suriname
Sweden 1 2
Switzerland 1 1 3 7
Syria
Taiwan
Tanzania 1
Thailand 3 1
Trinidad and Tobago 6
Tunisia
Turkey 1 2 7
Turkmenistan
U.S. Virgin Islands
Uganda 1 5
Ukraine 1 6
United Arab Emirates 1 1 4 4
United Kingdom 10 20 22 71 78 143
United States 4 26 67 134 317 511
Uruguay 1 2
Vanuatu
Venezuela 5
Vietnam 5 6
Yemen
Zambia
Zimbabwe 10 12 13 14 15 16
All Countries 57 62 183 380 764 1281
Zimbabwe

2011 2011 2011 2012 2012 2012

Oct Nov Dec Jan Feb Mar

7 8 9 10

2011 2012 2012 2012

Dec Jan Feb Mar
17 18 19 20

2011 2012 2012 2012 Grand Total

Dec Jan Feb Mar
6 3 10
1 1
1 2
3 5 3 17 34
3 3
1 1
59 140 209 338 830
12 9 12 14 51
2 2
26 3 32
3 2 7 7 19
1 4 3 11
1 11 1 13
4 2 47 40 101
1 1
 1 1
1 1
4 3 2 9
2 1 3
6 8 39 36 94
13 8 21
1 1 10 21 35
1 1 1 4
1
48 65 241 427 911
4 2 8
3 34 20 74
5 2 2 1 18
4 1 5
78 206 163 450
2 1 4
2 3 2 4 12
2 8 13 80 110
1
1 1 2
1 5 6
7 2 12 11 35
6
3 3 5 12
8 2 3 13
55 30 35 18 160
8 11 58 67 173
1 2 1 2 6
19 27 71 66 221
2 2 4
2 2 24 11 47
2 3
2 1 4
1 1 2
5 39 36 42 152
1 5 2 4 16
1 1 2
231 394 620 767 2312
3 15 36 48 115
1 1 3 16 23
1 1 4 11 17
1 6 61 66 155
4 1 10 26 82
2 6 19 24 58
2
 4 5 28 9 54
2 5 7
1 8 61
2
1 2 5 9
7 5 12 29
2 2
2 2 3 2 9
1 1 9 12
1 1
4 1 1 6
1 1 2
1 1 2
1 1
1 1
27 15 72 51 173
1 39 40
19 19
2 2
4 14 12 37
1 1 1 4
1 1
3 1 10
1 1 2
3 3
1 2 2 6
9 32 60 110 260
1 1 2
7 5 26 62 110
5 11 15 32
1 3 24 20 49
2 10 11 25
16 27 58 92 222
5 6
3 4
1 1
1 7 5 13
14 28 57 66 208
4 4 28 11 55
8 10 20 9 51
3 3 6
1 2 2 24 38
1 17 34 67
1 1 23 12 48
4 5 59 57 139
 2 2
2 2 7 27 62
27 24 79 114 295
1 4 2 4 11
2 2 17 33
1 1
5 13 40 47 129
1 1 11 6 23
2 5 22 34 84
2 8 14 16 42
1 3 4
1 1
3 31 28 27 92
3 11 21 26 73
5 1 5 11
1 1 3 6 11
1 2
4 45 39 92
1 26 33
1 3 4
5 7 40 22 84
1 1
1 1
1 7
5 2 14
12 8 75 67 172
63 658 711 649 2425
610 1168 2889 3083 8809
3
1 1
3 1 9
12 10 7 20 60
1 1 2
12 9 21
17 18 19 20 3
1375 3025 6452 7370 20949
Selecting Chart Source Data using a Combo Box Form Control Dropdown

Combo Box Dropdown

All Countries
8000

7000

6000

5000

4000

3000

2000

1000

0
2011 2011 2011 2011 2011 2011
Jun Jul Aug Sep Oct Nov

Selected Row 141

Column Number 1 2 3 4 5 6

2011 2011 2011 2011 2011 2011

Date Jun Jul Aug Sep Oct Nov

All Countries 57 62 183 380 764 1281

Source: Google Analytics for www.launchexcel.com

Sum of Pageviews 2011 2011 2011 2011 2011 2011
Country Jun Jul Aug Sep Oct Nov
Albania 1
Algeria
Angola 1
Argentina 4 2
Armenia
Aruba
Australia 1 3 13 6 31 30
Austria 2 2
Azerbaijan
Bahrain 2 1
Bangladesh
Barbados 3
Belarus
Belgium 2 6
Belize
Benin
Bhutan
Bosnia and Herzegovina
Botswana
Brazil 3 2
Brunei
Bulgaria 2
Cambodia 1
Cameroon 1
Canada 11 1 5 15 41 57
Chile 2
China 1 2 11 3
Colombia 8
Costa Rica
Croatia 3
Cyprus 1
Czech Republic 1
Denmark 3 1 3
Dominica 1
Dominican Republic
Ecuador
Egypt 1 2
El Salvador 6
Estonia 1
Ethiopia
Finland 1 21
France 2 1 6 20
Georgia
Germany 1 6 2 5 24
Ghana
Greece 2 4 2
Guam 1
Guatemala 1
Honduras
Hong Kong 9 2 19
Hungary 2 2
Iceland
India 14 7 21 62 85 111
Indonesia 3 2 1 7
Iran 1 1
Iraq
Ireland 9 3 6 3
Israel 14 7 20
Italy 1 3 3
Jamaica 2
Japan 2 6
Jersey
Jordan 52
Kazakhstan 2
Kenya 1
Kuwait 5
Laos
Latvia
Lebanon 1
Libya
Lithuania
Luxembourg
Macau
Macedonia [FYROM]
Malawi
Malaysia 1 1 6
Maldives
Malta
Mauritius
Mexico 4 1 1 1
Mongolia 1
Montenegro
Morocco 6
Myanmar [Burma]
Namibia
Nepal 1
Netherlands 1 5 34 9
Netherlands Antilles
New Zealand 3 7
Nigeria 1
Norway 1
Oman 2
Pakistan 1 6 22
Palestinian Territories 1
Papua New Guinea 1
Paraguay
Peru
Philippines 1 2 6 10 24
Poland 1 1 6
Portugal 1 1 2
Puerto Rico
Qatar 3 5 1
Romania 2 6 7
Russia 4 6 1
Saudi Arabia 2 8 4
Senegal
Serbia 1 23
Singapore 16 7 22 6
Slovakia
Slovenia 1 11
Solomon Islands
South Africa 3 10 11
South Korea 2 2
Spain 4 5 12
Sri Lanka 1 1
Sudan
Suriname
Sweden 1 2
Switzerland 1 1 3 7
Syria
Taiwan
Tanzania 1
Thailand 3 1
Trinidad and Tobago 6
Tunisia
Turkey 1 2 7
Turkmenistan
U.S. Virgin Islands
Uganda 1 5
Ukraine 1 6
United Arab Emirates 1 1 4 4
United Kingdom 10 20 22 71 78 143
United States 4 26 67 134 317 511
Uruguay 1 2
Vanuatu
Venezuela 5
Vietnam 5 6
Yemen
Zambia
Zimbabwe
All Countries 57 62 183 380 764 1281
All Countries

2011 2011 2011 2012 2012 2012

Oct Nov Dec Jan Feb Mar

7 8 9 10

2011 2012 2012 2012

Dec Jan Feb Mar
1375 3025 6452 7370

2011 2012 2012 2012 Grand Total

Dec Jan Feb Mar
6 3 10
1 1
1 2
3 5 3 17 34
3 3
1 1
59 140 209 338 830
12 9 12 14 51
2 2
26 3 32
3 2 7 7 19
1 4 3 11
1 11 1 13
4 2 47 40 101
1 1
 1 1
1 1
4 3 2 9
2 1 3
6 8 39 36 94
13 8 21
1 1 10 21 35
1 1 1 4
1
48 65 241 427 911
4 2 8
3 34 20 74
5 2 2 1 18
4 1 5
78 206 163 450
2 1 4
2 3 2 4 12
2 8 13 80 110
1
1 1 2
1 5 6
7 2 12 11 35
6
3 3 5 12
8 2 3 13
55 30 35 18 160
8 11 58 67 173
1 2 1 2 6
19 27 71 66 221
2 2 4
2 2 24 11 47
2 3
2 1 4
1 1 2
5 39 36 42 152
1 5 2 4 16
1 1 2
231 394 620 767 2312
3 15 36 48 115
1 1 3 16 23
1 1 4 11 17
1 6 61 66 155
4 1 10 26 82
2 6 19 24 58
2
 4 5 28 9 54
2 5 7
1 8 61
2
1 2 5 9
7 5 12 29
2 2
2 2 3 2 9
1 1 9 12
1 1
4 1 1 6
1 1 2
1 1 2
1 1
1 1
27 15 72 51 173
1 39 40
19 19
2 2
4 14 12 37
1 1 1 4
1 1
3 1 10
1 1 2
3 3
1 2 2 6
9 32 60 110 260
1 1 2
7 5 26 62 110
5 11 15 32
1 3 24 20 49
2 10 11 25
16 27 58 92 222
5 6
3 4
1 1
1 7 5 13
14 28 57 66 208
4 4 28 11 55
8 10 20 9 51
3 3 6
1 2 2 24 38
1 17 34 67
1 1 23 12 48
4 5 59 57 139
 2 2
2 2 7 27 62
27 24 79 114 295
1 4 2 4 11
2 2 17 33
1 1
5 13 40 47 129
1 1 11 6 23
2 5 22 34 84
2 8 14 16 42
1 3 4
1 1
3 31 28 27 92
3 11 21 26 73
5 1 5 11
1 1 3 6 11
1 2
4 45 39 92
1 26 33
1 3 4
5 7 40 22 84
1 1
1 1
1 7
5 2 14
12 8 75 67 172
63 658 711 649 2425
610 1168 2889 3083 8809
3
1 1
3 1 9
12 10 7 20 60
1 1 2
12 9 21
3 3
1375 3025 6452 7370 20949
 Pageviews 2011 2011 2011 2011 2011
Top_20_Country Jun Jul Aug Sep Oct

Australia 1 3 13 6 31
21

Canada 11 1 5 15 41

Croatia

Finland 1

France 2 1 6

Germany 1 6 2 5

Hong Kong 9 2

India 14 7 21 62 85

Indonesia 3 2 1

Ireland 9 3 6

Malaysia 1 1
Netherlands 1 5 34

Pakistan 1 6

Philippines 1 2 6 10

Saudi Arabia 2 8

Singapore 16 7 22

South Africa 3 10

United Arab Emirates 1 1 4

United Kingdom 10 20 22 71 78

United States 4 26 67 134 317

Grand Total 49 60 162 332 676

2011 2011 2012 2012 2012 Grand Total
Nov Dec Jan Feb Mar Top_20_Flag http://www.public-domain-image.com/

30 59 140 209 338 830

57 48 65 241 427 911

3 78 206 163 450

21 55 30 35 18 160

20 8 11 58 67 173

24 19 27 71 66 221

19 5 39 36 42 152

111 231 394 620 767 2312

7 3 15 36 48 115

3 1 6 61 66 155

6 27 15 72 51 173
 9 9 32 60 110 260

22 16 27 58 92 222

24 14 28 57 66 208

4 4 5 59 57 139

6 27 24 79 114 295

11 5 13 40 47 129

4 12 8 75 67 172

143 63 658 711 649 2425

511 610 1168 2889 3083 8809

1043 1248 2822 5758 6407 18557 Picture: PaperMap2 by fangol

ww.public-domain-image.com/flags-of-the-world-public-domain-images-pictures/
aperMap2 by fangol
Name Refers to On Sheet Sheet level
DropDown1!Db1_Country =DropDown1!$B$15:$B$155 DropDown1 TRUE
DropDown1!Db1_Pageviews =DropDown1!$C$15:$L$155 DropDown1 TRUE
DropDown1!Db1_Selected_Row =DropDown1!$C$7 DropDown1 TRUE
DropDown2!Db2_Country =DropDown2!$B$15:$B$155 DropDown2 TRUE
DropDown2!Db2_Pageviews =DropDown2!$C$15:$L$155 DropDown2 TRUE
DropDown2!Db2_Selected_Row =DropDown2!$C$7 DropDown2 TRUE
imgFlag =OFFSET(Top_20!$O$2,Top_20!$A$3,,1,1) Top_20 FALSE
Top_20_Country =Top_20!$C$3:$C$23 Top_20 FALSE
Top_20_Flag =Top_20!$O$3:$O$23 Top_20 FALSE