00:00so one of the types of charts that you can actually go ahead and add in Excel is the spark
00:10lines so to do that you can select let's say for example a line right here and then what you can
00:16do is you can go around over here on to the insert menu right here and then here you can see that
00:24spark lines is an option which allows you to add in line column or wind loss press the select line
00:30right here and then the location range right here for where I want the spark line is here so let me
00:35just go ahead and select and press enter press ok then you get the spark line right here depending
00:41on the value that you have right here as you can see so if I were to go ahead and change out let's
00:45say this value you can see that this changes out accordingly right here so now I actually went
00:51ahead and selected out this range for the spark line as well but let me just go ahead and select
00:56out this spark line right here just like this so now if I were to go around over here onto edit data
01:02you can see that it's from a2 to d2 right here but I want it from b2 only so I can go ahead and make
01:09the change and you can see it out right here so if I were to go around over here add in 87 you can see
01:14that it adjusts accordingly I can click and drag this out and what happens is that you can see
01:19that it reflects out all of these data so if I were to go around and type in 800 you can see
01:25that the spark line changes out go around over here and insert and then you can go ahead right
01:30here and let's say for example add in a value and then what happens is that you'll be able to see the
01:36change of spark line right here you can go to spark line right here and change around the color of it
01:43as you like as well and then go around over here onto column and choose the column work around with win
01:48and losses right here and even go ahead and then change out the
01:52options right here like you can choose to show different options right here work around with column
01:59work around with line as you can see right here and then see it out you can even go ahead and choose
02:04your own color as you want and then you can use these options right here to change around the axis
02:09as well as you want so this is what you have right here you can go ahead and short axis as you want
02:15and then even work around with different options you can edit out data and so forth so that is how
02:21you can go ahead and use spot lines that is bring in incel charts inside of microsoft excel so hope you
02:29found this video useful be sure to hit the like button don't forget to share this out with your friends
02:35and family and for more contents like these do follow simple tutorials
