This shape represents a slicer. Slicers are supported in Excel 2010 or later.
If the shape was modified in an earlier version of Excel, or if the workbook was saved in Excel 2003 or earlier, the
TRUE TRUE TRUE
✘ Dashboard 1 ✘ Dashboard 2 ✘ Dashboard 3
Sales Executive Sum of Total Sales Sales Executive Sum of Total Sales Sales Executive
Anikuttan 382 Dinesh Kumar 166 Anikuttan
Arvind Sharma 379 Omprakash O 143 Arvind Sharma
Jagdish Chandra 389 Pankaj Shelkey 156 Jagdish Chandra
Miny Mole 384 Prabha Desikan 171 Miny Mole
Rachita Anupam 385 Praveen Kumar 166 Rachita Anupam
Rachita
385
Anupam
Miny Mole 384
21% 21%
Jagdish
389
Chandra
21% 18%
Arvind Sharma 379
19%
Anikuttan 382
Excel 2003 or earlier, the slicer cannot be used.
TRUE
hboard 3 ✘ Dashboard 4
Sum of Target Hit % Sales Executive Sum of Target Hit %
76.40% Dinesh Kumar 33.20%
75.80% Omprakash O 28.60%
77.80% Pankaj Shelkey 31.20%
76.80% Prabha Desikan 34.20%
77.00% Praveen Kumar 33.20%
34.20%
33.20% 33.20%
31.20%
28.60%
Emp Code Sales Executive RegionDay1Day2Day3Day4Day5
Total Sales
Target
Target Hit %
Mum-TCL001 Raj Verma Mumbai 49 84 98 67 41 339 500 67.80%
Mum-TCL002 Tanuja Kale Delhi 44 85 47 15 48 239 500 47.80%
Mum-TCL003 Arvind Sharma Nagpur 45 79 88 73 94 379 500 75.80%
Mum-TCL004 Tahira Qureshi Chennai 52 99 13 95 29 288 500 57.60%
Mum-TCL005 Anuj Sharma Pune 35 54 49 26 49 213 500 42.60%
Mum-TCL006 Syed Sohail Patna 86 31 23 48 77 265 500 53.00%
Mum-TCL007 Syed Saqib Ranchi 84 28 98 80 79 369 500 73.80%
Mum-TCL008 Syed Naved Surat 73 97 38 24 53 285 500 57.00%
Mum-TCL009 Swarnlata Borse Mumbai 54 26 53 36 20 189 500 37.80%
Mum-TCL010 Sushma Khandelwal Delhi 52 52 19 53 37 213 500 42.60%
Mum-TCL011 Surendranath Thakur Nagpur 63 17 40 48 51 219 500 43.80%
Mum-TCL012 Surendra Kumar Chennai 79 99 95 12 91 376 500 75.20%
Mum-TCL013 Sunita Madnani Pune 95 88 11 78 60 332 500 66.40%
Mum-TCL014 Sunita Chawla Patna 83 77 66 22 40 288 500 57.60%
Mum-TCL015 Sunil Kumar Ranchi 78 58 34 84 31 285 500 57.00%
Mum-TCL016 Sudhir Kumar Surat 14 25 45 70 45 199 500 39.80%
Mum-TCL017 Sudama Kumar Mumbai 37 69 96 66 38 306 500 61.20%
Mum-TCL018 Sonaram Munda Delhi 11 46 91 98 45 291 500 58.20%
Mum-TCL019 Sneh Khan Nagpur 19 34 64 65 70 252 500 50.40%
Mum-TCL020 Shyamal Malakar Chennai 93 84 13 45 18 253 500 50.60%
Mum-TCL021 Shubhanjali Joshi Pune 68 73 97 76 53 367 500 73.40%
Mum-TCL022 Shivji Prasad Patna 99 17 48 44 93 301 500 60.20%
Mum-TCL023 Shephali Jain Ranchi 57 28 31 34 52 202 500 40.40%
Mum-TCL024 Sheena Joseph Surat 40 22 18 11 92 183 500 36.60%
Mum-TCL025 Sheeba Joseph Mumbai 47 99 94 75 29 344 500 68.80%
Mum-TCL026 Shashikant Tiwari Delhi 16 71 80 76 33 276 500 55.20%
Mum-TCL027 Shankar Attendant Nagpur 72 87 92 72 34 357 500 71.40%
Mum-TCL028 Shailendra Barge Chennai 30 38 70 89 97 324 500 64.80%
Mum-TCL029 Shailaja Kamal Pune 65 90 91 85 10 341 500 68.20%
Mum-TCL030 Saroj Parita Patna 83 46 99 36 89 353 500 70.60%
Mum-TCL031 Sapna Sharma Ranchi 10 66 40 22 38 176 500 35.20%
Mum-TCL032 Santosh Kumar Surat 37 30 19 77 67 230 500 46.00%
Mum-TCL033 Sanju Ramdas Mumbai 83 46 17 94 92 332 500 66.40%
Mum-TCL034 Sanjiv Subherwal Delhi 84 59 41 17 22 223 500 44.60%
Mum-TCL035 Sanjay Hire Nagpur 82 54 79 61 47 323 500 64.60%
Mum-TCL036 Salim Chennai 47 23 19 64 61 214 500 42.80%
Mum-TCL037 Sajid Naqvi Pune 91 13 79 85 67 335 500 67.00%
Mum-TCL038 Roohi Haider Patna 66 59 25 55 59 264 500 52.80%
Mum-TCL039 Roma Rastogi Ranchi 70 18 88 46 52 274 500 54.80%
Mum-TCL040 Roli Bhatnagar Surat 37 60 44 61 30 232 500 46.40%
Mum-TCL041 Rohit Nishchal Mumbai 16 46 33 54 58 207 500 41.40%
Mum-TCL042 Ritu Bhatnagar Delhi 47 97 74 97 56 371 500 74.20%
Mum-TCL043 Renu Pratap Nagpur 86 22 10 60 28 206 500 41.20%
Mum-TCL044 Rekha Jain Chennai 74 17 45 64 13 213 500 42.60%
Mum-TCL045 Rekha Gupta Pune 80 51 15 97 42 285 500 57.00%
Mum-TCL046 Rekha Agarwal Patna 49 82 95 46 78 350 500 70.00%
Mum-TCL047 Ravinder Kaur Ranchi 17 88 12 54 21 192 500 38.40%
Mum-TCL048 Ravi Kumar Surat 74 16 74 36 33 233 500 46.60%
Mum-TCL049 Rashmi Gajbe Mumbai 73 72 38 19 90 292 500 58.40%
Mum-TCL050 Rashid Delhi 17 84 90 77 72 340 500 68.00%
Mum-TCL051 Ramji Prasad Nagpur 52 36 84 41 57 270 500 54.00%
Mum-TCL052 Rakhi Jodhani Chennai 65 67 72 22 23 249 500 49.80%
Mum-TCL053 Rajshree Dhabekar Pune 88 39 25 99 71 322 500 64.40%
Mum-TCL054 Raji Abraham Patna 23 14 15 58 79 189 500 37.80%
Mum-TCL055 Rajesh Sharma Ranchi 15 67 48 95 35 260 500 52.00%
Mum-TCL056 Rajesh Kumar Surat 18 35 82 31 26 192 500 38.40%
Mum-TCL057 Rajendra Prasad Mumbai 57 60 42 81 44 284 500 56.80%
Mum-TCL058 Rajendra Kumar Delhi 34 97 66 45 50 292 500 58.40%
Mum-TCL059 Rajendra Gupta Nagpur 83 12 70 83 52 300 500 60.00%
Mum-TCL060 Rajeev Kumar Chennai 76 55 56 16 61 264 500 52.80%
Mum-TCL061 Rajeev Garg Pune 40 70 19 36 52 217 500 43.40%
Mum-TCL062 Raj Kumar Patna 44 60 71 34 37 246 500 49.20%
Mum-TCL063 Rachna Chauhan Ranchi 43 78 15 98 33 267 500 53.40%
Mum-TCL064 Rachita Anupam Surat 75 75 89 97 49 385 500 77.00%
Mum-TCL065 Rachel Mathew Mumbai 74 51 97 73 33 328 500 65.60%
Mum-TCL066 Praveen Kumar Delhi 44 36 11 45 30 166 500 33.20%
Mum-TCL067 Prasannakumari S Nagpur 87 79 46 65 65 342 500 68.40%
Mum-TCL068 Pramod Tiwari Chennai 70 52 80 43 48 293 500 58.60%
Mum-TCL069 Prabha Desikan Pune 45 26 27 14 59 171 500 34.20%
Mum-TCL070 Partha Sarathi Patna 51 26 58 83 11 229 500 45.80%
Mum-TCL071 Pankaj Shelkey Ranchi 68 36 15 20 17 156 500 31.20%
Mum-TCL072 Owais Mohd Surat 32 74 18 33 51 208 500 41.60%
Mum-TCL073 Omprakash O Mumbai 41 11 46 35 10 143 500 28.60%
Mum-TCL074 Om Prakash Delhi 41 17 82 75 39 254 500 50.80%
Mum-TCL075 Nitin Bhatia Nagpur 12 97 45 29 41 224 500 44.80%
Mum-TCL076 Nikita Panwalkar Chennai 19 72 87 82 27 287 500 57.40%
Mum-TCL077 Neeru Mehta Pune 98 15 72 67 34 286 500 57.20%
Mum-TCL078 Neeraj Saxena Patna 50 44 46 13 92 245 500 49.00%
Mum-TCL079 Narayan Singh Ranchi 40 82 72 42 45 281 500 56.20%
Mum-TCL080 Nandu Kumar Surat 23 83 63 65 83 317 500 63.40%
Mum-TCL081 Mukesh Nagar Mumbai 71 94 45 95 46 351 500 70.20%
Mum-TCL082 Mubeen Khan Delhi 48 49 68 23 21 209 500 41.80%
Mum-TCL083 Mohd Rafi Nagpur 77 83 64 53 13 290 500 58.00%
Mum-TCL084 Miny Mole Chennai 81 63 88 89 63 384 500 76.80%
Mum-TCL085 Mercy Thampi Pune 39 87 62 80 81 349 500 69.80%
Mum-TCL086 Mehnaz Khan Patna 46 19 59 58 33 215 500 43.00%
Mum-TCL087 Meena Zinjare Ranchi 34 15 43 63 54 209 500 41.80%
Mum-TCL088 Masroor Adil Surat 32 79 65 57 73 306 500 61.20%
Mum-TCL089 Manoj Kumar Mumbai 72 82 58 36 33 281 500 56.20%
Mum-TCL090 ManjuTiwari Lab Delhi 11 69 49 90 99 318 500 63.60%
Mum-TCL091 Manjusha Sinha Nagpur 80 73 21 72 54 300 500 60.00%
Mum-TCL092 Manisha Shrivastava Chennai 93 42 38 98 10 281 500 56.20%
Mum-TCL093 Mangal Singh Pune 18 80 20 32 95 245 500 49.00%
Mum-TCL094 Lilly Lucy Patna 96 14 20 31 44 205 500 41.00%
Mum-TCL095 Leena George Ranchi 37 60 50 68 19 234 500 46.80%
Mum-TCL096 Kunj Bihari Surat 35 79 17 85 16 232 500 46.40%
Mum-TCL097 Krishana Kumar Mumbai 31 48 56 85 25 245 500 49.00%
Mum-TCL098 Kisun Sah Delhi 23 83 86 69 25 286 500 57.20%
Mum-TCL099 Kiran Khubchandani Nagpur 17 97 81 32 76 303 500 60.60%
Mum-TCL100 Kavita Sharma Chennai 92 45 43 91 47 318 500 63.60%
Mum-TCL101 Kamini Tiwari Pune 49 77 18 69 55 268 500 53.60%
Mum-TCL102 Kamini Kumar Patna 81 88 19 95 39 322 500 64.40%
Mum-TCL103 Kalpana Agrawal Ranchi 55 14 41 40 70 220 500 44.00%
Mum-TCL104 Kailash Nath Surat 86 13 99 25 83 306 500 61.20%
Mum-TCL105 Kahkasha Parveen Mumbai 88 96 16 65 86 351 500 70.20%
Mum-TCL106 Jyoti Tulsani Delhi 61 73 34 30 30 228 500 45.60%
Mum-TCL107 Julie S Nagpur 61 91 53 78 91 374 500 74.80%
Mum-TCL108 John D'Costa Chennai 75 53 27 26 30 211 500 42.20%
Mum-TCL109 Jitendra Kumar Pune 24 31 41 57 83 236 500 47.20%
Mum-TCL110 Janardan Mishra Patna 83 62 32 83 95 355 500 71.00%
Mum-TCL111 Jairaj Vatham Ranchi 39 52 72 99 58 320 500 64.00%
Mum-TCL112 Jagdish Chandra Surat 93 74 85 47 90 389 500 77.80%
Mum-TCL113 Indra Singh Mumbai 43 88 35 54 91 311 500 62.20%
Mum-TCL114 Indra Pal Delhi 87 15 11 42 88 243 500 48.60%
Mum-TCL115 Heeramani Choudhary Nagpur 45 45 61 11 52 214 500 42.80%
Mum-TCL116 Hari Kumar Chennai 71 42 17 57 96 283 500 56.60%
Mum-TCL117 Dinesh Kumar Pune 26 65 17 28 30 166 500 33.20%
Mum-TCL118 Deepika Nigam Patna 26 61 89 71 33 280 500 56.00%
Mum-TCL119 Deepak Kumar Ranchi 93 11 93 31 30 258 500 51.60%
Mum-TCL120 Daleep Singh Surat 65 92 48 96 15 316 500 63.20%
Mum-TCL121 Bindu Nair Mumbai 91 38 33 55 83 300 500 60.00%
Mum-TCL122 Bhagwat Singh Delhi 20 94 45 70 98 327 500 65.40%
Mum-TCL123 Azam Nagpur 25 83 26 68 22 224 500 44.80%
Mum-TCL124 Atul Kumar Chennai 26 16 61 92 50 245 500 49.00%
Mum-TCL125 Ashok Mahto Pune 31 55 75 66 75 302 500 60.40%
Mum-TCL126 Ashok Kumar Patna 41 66 48 70 48 273 500 54.60%
Mum-TCL127 Ashish Kumar Ranchi 60 92 32 60 78 322 500 64.40%
Mum-TCL128 Arun Kumar Surat 42 24 19 82 16 183 500 36.60%
Mum-TCL129 Anubhuti Gupta Mumbai 26 85 75 83 37 306 500 61.20%
Mum-TCL130 Anoop Raj Delhi 81 68 74 72 12 307 500 61.40%
Mum-TCL131 Anoop Narayan Nagpur 90 79 99 60 27 355 500 71.00%
Mum-TCL132 Annu Latika Chennai 71 21 70 53 49 264 500 52.80%
Mum-TCL133 Anjali Sahay Pune 86 60 59 51 90 346 500 69.20%
Mum-TCL134 Anjali Deoram Patna 68 61 12 41 35 217 500 43.40%
Mum-TCL135 Anita Ghore Ranchi 65 34 15 86 71 271 500 54.20%
Mum-TCL136 Anita Dixit Surat 91 21 59 85 60 316 500 63.20%
Mum-TCL137 Anil Kumar Mumbai 73 67 49 56 43 288 500 57.60%
Mum-TCL138 Anikuttan Delhi 72 49 93 95 73 382 500 76.40%
Mum-TCL139 Anamika Gupta Nagpur 85 43 74 26 88 316 500 63.20%
Mum-TCL140 Afzal Husain Chennai 77 81 10 65 83 316 500 63.20%
Mum-TCL141 Abdul Hamid Pune 46 52 57 67 64 286 500 57.20%
Away From Target %
32.20%
52.20%
24.20%
42.40%
57.40%
47.00%
26.20%
43.00%
62.20%
57.40%
56.20%
24.80%
33.60%
42.40%
43.00%
60.20%
38.80%
41.80%
49.60%
49.40%
26.60%
39.80%
59.60%
63.40%
31.20%
44.80%
28.60%
35.20%
31.80%
29.40%
64.80%
54.00%
33.60%
55.40%
35.40%
57.20%
33.00%
47.20%
45.20%
53.60%
58.60%
25.80%
58.80%
57.40%
43.00%
30.00%
61.60%
53.40%
41.60%
32.00%
46.00%
50.20%
35.60%
62.20%
48.00%
61.60%
43.20%
41.60%
40.00%
47.20%
56.60%
50.80%
46.60%
23.00%
34.40%
66.80%
31.60%
41.40%
65.80%
54.20%
68.80%
58.40%
71.40%
49.20%
55.20%
42.60%
42.80%
51.00%
43.80%
36.60%
29.80%
58.20%
42.00%
23.20%
30.20%
57.00%
58.20%
38.80%
43.80%
36.40%
40.00%
43.80%
51.00%
59.00%
53.20%
53.60%
51.00%
42.80%
39.40%
36.40%
46.40%
35.60%
56.00%
38.80%
29.80%
54.40%
25.20%
57.80%
52.80%
29.00%
36.00%
22.20%
37.80%
51.40%
57.20%
43.40%
66.80%
44.00%
48.40%
36.80%
40.00%
34.60%
55.20%
51.00%
39.60%
45.40%
35.60%
63.40%
38.80%
38.60%
29.00%
47.20%
30.80%
56.60%
45.80%
36.80%
42.40%
23.60%
36.80%
36.80%
42.80%