Microsoft Excel 49 Using Sparklines (In-cell Charts)

SimpleTutorials

Microsoft Excel is a powerful spreadsheet application used for organizing, analyzing, and visualizing data. In this course, you will learn the essential skills you need to get started and become confident in using Excel.  In this video lesson, we will learn about Using Sparklines (In-cell Charts) in Microsoft Excel  You can access the entire Microsoft Excel Course in the following playlist: https://www.dailymotion.com/playlist/xa9hyw

Transcript

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

Category

Transcript

Be the first to comment

Recommended