dashboard

Selecting Chart Source Data using Data Validation Dro Data Validation Dropdown All Countries 8000 7000 6000 5000 4000 3000 2000 1000 0 2011 !un !un

2011 !ul !ul

2011 Aug

Selected Row Column Number

141 1

2

3

4

Date

2011 !un

2011 !ul

2011 Aug

2011 "e#

57

62

183

380

All Countries

Source: Google Analytics for www.launchexcel.com Sum of Pageviews 2011 2011 2011 Country Jun Jul ug Albania Algeria Angola Argentina 4 Armenia Aruba Australia 1 3 13 Austria Azerbaijan Bahrain Banglaesh Barbaos 3 Belarus Belgium Belize

2011 Sep

6

2

Benin Bhutan Bosnia an )erzego&ina Bots*ana Brazil Brunei Bulgaria Camboia Cameroon Canaa Chile China Colombia Costa +i%a Croatia C,#rus Cze%h +e#ubli% DenmarDomini%a Domini%an +e#ubli% .%uaor .g,#t .l "al&aor .stonia .thio#ia 'inlan 'ran%e /eorgia /erman, /hana /ree%e /uam /uatemala )onuras )ong ong )ungar, %elan nia nonesia ran ra relan srael tal, !amai%a

1 11

1

5

15

1 8

2

1 3

1

1

2

1

6

2 2



14

7



21 3

62 2

3 14 1


1 11

1

5

15

1 8

2

1 3

1

1

2

1

6

2 2



14

7



21 3

62 2

3 14 1

!a#an !erse, !oran aza-hstan en,a u*ait aos at&ia ebanon ib,a ithuania uembourg (a%au (a%eonia '+$( (ala*i (ala,sia (ali&es (alta (auritius (ei%o (ongolia (ontenegro (oro%%o (,anmar Burma Namibia Ne#al Netherlans Netherlans Antilles Ne* 9ealan Nigeria Nor*a, $man :a-istan :alestinian ;erritories :a#ua Ne* /uinea :aragua, :eru :hili##ines :olan :ortugal :uerto +i%o
1

4

1

1 1

5

1 1

1

2

6 1

1 3 2 4 2

"enegal "erbia "inga#ore "lo&a-ia "lo&enia "olomon slans "outh A=ri%a "outh orea "#ain "ri an-a "uan "uriname "*een "*itzerlan ",ria ;ai*an ;anzania ;hailan ;rinia an ;obago ;unisia ;ur-e, ;ur-menistan >?"? @irgin slans >gana >-raine >nite Arab .mirates >nite ingom >nite "tates >rugua, @anuatu @enezuela @ietnam emen 9ambia 9imbab*e ll Countries

16

1 7

3 2 4 1

1

1

3

10 4

20 26

1

2

1 22 67

1 1 71 134 1

5

!"

#2

1

%$%$0

down

ll Countries

2011 "e#

2011 $%t

2011 No&

2011 De%

2012 !an

2012 'eb

5

6

7

8



10

2011 $%t

2011 No&

2011 De%

2012 !an

2012 'eb

2012 (ar

764

1281

1375

3025

6452

7370

2011 (ct

2011 )ov

2011 Dec

2012 Jan

2012 *e+

2012 ,ar

1

6

&rand 'otal 3

1 1 2

31 2

30 2

2

1

3

5 12

3

6

1 4

5

140 

2 1 11 2

3 3 20 12 2 26 7 4 1 47

2012 (ar

1 17 1 338 14 3 7 3 40 1

10 1 2 34 3 1 830 51 2 32 1 11 13 101 1

1

3

2

2

41 11

1 57 2 3

6 1

1 1

48

65

5 3 1 1 1

3

4 2 8

2 2

3 2 4 78 3 8

3 1 3 13 10 1 241 4 34 2 206 2 2 13 1

2

7

1 2

12

30 11 2 27

3 2 35 58 1 71

2

24

3 5 1 34 15 1 1 6 1 6

1 1 36 2 1 620 36 3 4 61 10 1

1 2 36 8 21 1 427 2 20 1 1 163 1 4 80 1 5 11

6 1 1 6

21 20

5

24

4

2 1 1

3 8 55 8 1 1 2 2 2

2 2

1 2

5 1

85 1 1

111 7 1

6 7 3 2

3 20 3

231 3 1 1 1 4 2

5 3 18 67 2 66 2 11 2 1 42 4 767 48 16 11 66 26 24

1 1  3 4 21 35 4 1 11 8 74 18 5 450 4 12 110 1 2 6 35 6 12 13 160 173 6 221 4 47 3 4 2 152 16 2 2312 115 23 17 155 82 58 2

2

6

4

52 2

1

1 5 2 1

5 2

28

 5 8

1 7

2 5

2 1

3 1

4

1 1

5 12 2 2  1 1 1 1

1 1 1

1

6

1 1

27

15

2 4 1

6



3

7 1

6 1

2 22

14 1

3 1

34

72 1

 1 7 1 2 16

1 32 5 5 3 27

1 3 2 60 26 11 24 10 58 5

1

1 51 3 1 12 1 1 1

2 110 1 62 15 20 11 2 3

10 1 1

24 6 2

14 4 8

5 6 6 8

1 7 1 4

1 1 4

1 28 4 10 2 1 1 5

1 7 57 28 20 3 2 17 23 5

5 66 11  3 24 34 12 57

54 7 61 2  2 2  12 1 6 2 2 1 1 173 40 1 2 37 4 1 10 2 3 6 260 2 110 32 4 25 222 6 4 1 13 208 55 51 6 38 67 48 13

22

23 6

1

11

2 2 27 1 2

10

11 2 12 1

5 1 2 2

2 7

3 3 5 1

5

1 3

1 1 6 7

1 4 78 317 2

5

6

7 7 2 2

13 1 5 8 1 1 31 11

40 11 22 14 3

1 4

5 1 1 5 6 4 143 511

2 24 4

12 63 610

12

7

8 658 1168

3 10 1

28 21 1 3 45 1 1 40

27 26 5 6 1 3 26 3 22

5 75 711 288

1 2 67 64 3083

7 12

"#-

12$1

1%"!

%02!

27 114 4 17 1 47 6 34 16

#-!2

1 1 20 1  3 "%"0

2 62 25 11 33 1 12 23 84 42 4 1 2 73 11 11 2 2 33 4 84 1 1 7 14 172 2425 880 3 1  60 2 21 3 20.-.

Selecting Chart Source Data using a Com+o /o *orm C Com+o /o Dropdown

8000 7000 6000 5000 4000 3000 2000 1000 0 2011 !un

2011 !ul

2011 Aug

Selected Row Column Number

141 1

2

3

4

Date

2011 !un

2011 !ul

2011 Aug

2011 "e#

57

62

183

380

All Countries

Source: Google Analytics for www.launchexcel.com Sum of Pageviews 2011 2011 2011 Country Jun Jul ug Albania Algeria Angola Argentina 4 Armenia Aruba Australia 1 3 13 Austria Azerbaijan Bahrain Banglaesh Barbaos 3 Belarus Belgium Belize

2011 Sep

6

2


1 11

1

5

15

1 8

2

1 3

1

1

2

1

6

2 2



14

7



21 3

62 2

3 14 1

!a#an !erse, !oran aza-hstan en,a u*ait aos at&ia ebanon ib,a ithuania uembourg (a%au (a%eonia '+$( (ala*i (ala,sia (ali&es (alta (auritius (ei%o (ongolia (ontenegro (oro%%o (,anmar Burma Namibia Ne#al Netherlans Netherlans Antilles Ne* 9ealan Nigeria Nor*a, $man :a-istan :alestinian ;erritories :a#ua Ne* /uinea :aragua, :eru :hili##ines :olan :ortugal :uerto +i%o
1

4

1

1 1

5

1 1

1

2

6 1

1 3 2 4 2

"enegal "erbia "inga#ore "lo&a-ia "lo&enia "olomon slans "outh A=ri%a "outh orea "#ain "ri an-a "uan "uriname "*een "*itzerlan ",ria ;ai*an ;anzania ;hailan ;rinia an ;obago ;unisia ;ur-e, ;ur-menistan >?"? @irgin slans >gana >-raine >nite Arab .mirates >nite ingom >nite "tates >rugua, @anuatu @enezuela @ietnam emen 9ambia 9imbab*e ll Countries

16

1 7

3 2 4 1

1

1

3

10 4

20 26

1

2

1 22 67

1 1 71 134 1

5

!"

#2

1

%$%$0

ontrol Dropdown

ll Countries

2011 "e#

2011 $%t

2011 No&

2011 De%

2012 !an

2012 'eb

5

6

7

8



10

2011 $%t

2011 No&

2011 De%

2012 !an

2012 'eb

2012 (ar

764

1281

1375

3025

6452

7370

2011 (ct

2011 )ov

2011 Dec

2012 Jan

2012 *e+

2012 ,ar

1

6

2012 (ar

&rand 'otal 3

1 1 2

31 2

30 2

2

1

3

5 12

3

6

1 4

5

140 

2 1 11 2

3 3 20 12 2 26 7 4 1 47

1 17 1 338 14 3 7 3 40 1

10 1 2 34 3 1 830 51 2 32 1 11 13 101 1

1

3

2

2

41 11

1 57 2 3

6 1

1 1

48

65

5 3 1 1 1

3

4 2 8

2 2

3 2 4 78 3 8

3 1 3 13 10 1 241 4 34 2 206 2 2 13 1

2

7

1 2

12

30 11 2 27

3 2 35 58 1 71

2

24

3 5 1 34 15 1 1 6 1 6

1 1 36 2 1 620 36 3 4 61 10 1

1 2 36 8 21 1 427 2 20 1 1 163 1 4 80 1 5 11

6 1 1 6

21 20

5

24

4

2 1 1

3 8 55 8 1 1 2 2 2

2 2

1 2

5 1

85 1 1

111 7 1

6 7 3 2

3 20 3

231 3 1 1 1 4 2

5 3 18 67 2 66 2 11 2 1 42 4 767 48 16 11 66 26 24

1 1  3 4 21 35 4 1 11 8 74 18 5 450 4 12 110 1 2 6 35 6 12 13 160 173 6 221 4 47 3 4 2 152 16 2 2312 115 23 17 155 82 58 2

2

6

4

52 2

1

1 5 2 1

5 2

28

 5 8

1 7

2 5

2 1

3 1

4

1 1

5 12 2 2  1 1 1 1

1 1 1

1

6

1 1

27

15

2 4 1

6



3

7 1

6 1

2 22

14 1

3 1

34

72 1

 1 7 1 2 16

1 32 5 5 3 27

1 3 2 60 26 11 24 10 58 5

1

1 51 3 1 12 1 1 1

2 110 1 62 15 20 11 2 3

10 1 1

24 6 2

14 4 8

5 6 6 8

1 7 1 4

1 1 4

1 28 4 10 2 1 1 5

1 7 57 28 20 3 2 17 23 5

5 66 11  3 24 34 12 57

54 7 61 2  2 2  12 1 6 2 2 1 1 173 40 1 2 37 4 1 10 2 3 6 260 2 110 32 4 25 222 6 4 1 13 208 55 51 6 38 67 48 13

22

23 6

1

11

2 2 27 1 2

10

11 2 12 1

5 1 2 2

2 7

3 3 5 1

5

1 3

1 1 6 7

1 4 78 317 2

5

6

7 7 2 2

13 1 5 8 1 1 31 11

40 11 22 14 3

1 4

5 1 1 5 6 4 143 511

2 24 4

12 63 610

12

7

8 658 1168

3 10 1

28 21 1 3 45 1 1 40

27 26 5 6 1 3 26 3 22

5 75 711 288

1 2 67 64 3083

7 12

"#-

12$1

1%"!

%02!

27 114 4 17 1 47 6 34 16

#-!2

1 1 20 1  3 "%"0

2 62 25 11 33 1 12 23 84 42 4 1 2 73 11 11 2 2 33 4 84 1 1 7 14 172 2425 880 3 1  60 2 21 3 20.-.

Pageviews 'op20Country Australia

2011 Jun

2011 Jul

2011 ug

1

3

13

11

1

5

21 Canaa

Croatia

'inlan

'ran%e

2

/erman,

1

6

7

21

)ong ong

nia

14

nonesia

relan

(ala,sia

3



Netherlans

1

:a-istan

1

:hili##ines

1

2

"aui Arabia

"inga#ore

16

"outh A=ri%a

>nite Arab .mirates

>nite ingom

1

10

20

22

>nite "tates

4

26

67

&rand 'otal

-.

#0

1#2

2011 Sep

2011 (ct

2011 )ov

2011 Dec

2012 Jan

2012 *e+

2012 ,ar

&rand 'ot

6

31

30

5

140

20

338

830

15

41

57

48

65

241

427

11

78

206

163

450

3

1

21

55

30

35

18

160

1

6

20

8

11

58

67

173

2

5

24

1

27

71

66

221



2

1

5

3

36

42

152

62

85

111

231

34

620

767

2312

2

1

7

3

15

36

48

115

3

6

3

1

6

61

66

155

1

1

6

27

15

72

51

173

5

34





32

60

110

260

6

22

16

27

58

2

222

6

10

24

14

28

57

66

208

2

8

4

4

5

5

57

13

7

22

6

27

24

7

114

25

3

10

11

5

13

40

47

12

1

4

4

12

8

75

67

172

71

78

143

63

658

711

64

2425

134

317

511

610

1168

288

3083

880

%%2

#"#

10-%

12-$

2$22

!"!$

#-0"

1$!!"

dashboard

Recommend Documents