1 00:00:01,440 --> 00:00:09,970 In this video we will learn about Spotlight spotlight and the many charge that reside in a cell in exile. 2 00:00:09,990 --> 00:00:14,160 As you can see here I have used battlelines drawn. 3 00:00:14,160 --> 00:00:16,980 You can see in this single cell all five. 4 00:00:17,610 --> 00:00:26,910 I have this small line chart which is representing the trend of these values so spotlights are usually 5 00:00:26,910 --> 00:00:31,200 used to show a trend over time or the variation in the dataset. 6 00:00:31,980 --> 00:00:40,480 However since spot lines are really tiny they have limited functionality despite that smart lines are 7 00:00:40,480 --> 00:00:40,990 great. 8 00:00:41,110 --> 00:00:48,430 As you can create this easily to show a trend and make your reports and dashboard look more reader friendly. 9 00:00:50,480 --> 00:00:53,230 There are three types of spotlight. 10 00:00:53,480 --> 00:01:01,580 I tell you where to find this Portland go to insert and in this section you can see there are three 11 00:01:01,580 --> 00:01:11,540 types of Spotlight line column and willows to line will plot a line Jack and a singleton column will 12 00:01:11,540 --> 00:01:22,110 be a column chart and the loss will be a plus and minus table chart so let's learn how to create a sparkling 13 00:01:24,450 --> 00:01:25,290 and delete this 14 00:01:29,680 --> 00:01:34,550 go to insert line. 15 00:01:35,420 --> 00:01:46,060 So this will be a line type post modeling their data range is from C5 for to inflate and the selling 16 00:01:46,120 --> 00:01:52,220 which I wanted is Or finally if you want to change it you can change it here click on okay And here's 17 00:01:52,230 --> 00:01:54,280 a sparkling. 18 00:01:54,310 --> 00:02:00,940 So as I told you it's a small version of the line Jack let's draw a line chart want to compare whether 19 00:02:00,940 --> 00:02:03,820 this spot line the same as the line Jack 20 00:02:08,190 --> 00:02:12,180 so this is a line Jack. 21 00:02:12,370 --> 00:02:21,120 You can see that that trend that we will see in the line chart is also represented by this small sparkling. 22 00:02:21,220 --> 00:02:28,000 So whenever you are sharing a large amount of data with some other people in your workplace and in your 23 00:02:28,040 --> 00:02:34,660 worksheet you can not draw big chart small sparkling can only the purpose of highlighting that there 24 00:02:34,660 --> 00:02:38,920 is some trend in the data that you are offering them. 25 00:02:38,920 --> 00:02:44,540 One thing you should know there is that sense of sparkling is residing within a cell. 26 00:02:44,560 --> 00:02:49,750 So if you change the size of DC the size of sparkling will also change. 27 00:02:50,020 --> 00:02:56,020 So if I increase the height and weight the height and weight of sparkling will also change that. 28 00:02:56,050 --> 00:03:04,000 Also if I merge the cells around it this party line will be drawn in all those most fields 29 00:03:06,690 --> 00:03:09,350 so this will the line of spotlight. 30 00:03:09,360 --> 00:03:11,990 Second one is the column type. 31 00:03:12,120 --> 00:03:14,210 It is similar to the line partly. 32 00:03:15,130 --> 00:03:21,460 So let us create a column type sparkling I'll clear this to clear sparkling. 33 00:03:21,570 --> 00:03:27,690 You have to go to design option and within that there is a clear pattern so clear all 34 00:03:30,490 --> 00:03:38,700 so right now only one cell is elected or six and go to call them typos partly 35 00:03:42,660 --> 00:03:45,660 collecting data live location. 36 00:03:45,660 --> 00:03:50,330 Okay so you can see here's the column by sparkling. 37 00:03:50,400 --> 00:03:54,570 The height of the bar is representing the value of each data point. 38 00:03:56,760 --> 00:04:04,470 If you want the store expanded to multiple sales you then my store said all you can do is say is the 39 00:04:04,500 --> 00:04:06,750 sale to have a bigger sparkling 40 00:04:09,620 --> 00:04:18,790 this last type of spotlight is a win loss or positive negative people sparkling so whenever it devalues 41 00:04:18,790 --> 00:04:25,120 positive it will be shown as a blue box above an imaginary axis. 42 00:04:25,390 --> 00:04:31,170 Whenever it is negative it be shown as a red box below that imaginary axis. 43 00:04:31,300 --> 00:04:34,060 So to create this let us glitter closed 44 00:04:41,770 --> 00:04:55,120 the loss w orange Okay so you can see here's a very large type of sparkling. 45 00:04:55,250 --> 00:05:01,910 The only difference between column type of sparkling and a Windows type of sparkling is the height of 46 00:05:01,910 --> 00:05:09,350 column in a column sparkling is giving us the relative value of that particular data point. 47 00:05:09,350 --> 00:05:17,390 Whereas in this last type of spotlight the height of column is irrelevant. 48 00:05:17,390 --> 00:05:19,870 If it is above the axis it is positive. 49 00:05:20,030 --> 00:05:22,200 If it is below the Axis does negative. 50 00:05:22,520 --> 00:05:26,230 So it is plus or minus or been lost type of graph. 51 00:05:27,610 --> 00:05:32,870 So this is how we create spotlights or mini charts. 52 00:05:32,910 --> 00:05:35,480 You can also format these spotlights. 53 00:05:35,490 --> 00:05:37,140 You can change its color. 54 00:05:37,200 --> 00:05:40,940 You can change its marker color so all those options are also available. 55 00:05:40,950 --> 00:05:43,400 We are not going to discuss it in this lecture.