Creating and Managing Excel Charts | Thomas Fragale | Skillshare
Play Speed
  • 0.5x
  • 1x (Normal)
  • 1.25x
  • 1.5x
  • 2x
1 Lessons (1h 3m)
    • 1. Excel Charts for beginners Tutorial Excel 2007 2010 2013 2016 Bar chart Pie Chart 2axis line combo

  • --
  • Beginner level
  • Intermediate level
  • Advanced level
  • All levels
  • Beg/Int level
  • Int/Adv level

Community Generated

The level is determined by a majority opinion of students who have reviewed this class. The teacher's recommendation is shown until at least 5 student responses are collected.





About This Class

This video will teach you how to create and manage charts in Excel 2016, Excel 2013, Excel 2010, and Excel 2007.

It covers :

  • Column Charts
  • Sparklines
  • Pie Charts
  • Doughnut Charts
  • Pie-in-Bar Charts
  • Combo Charts (formerly known as 2-Axis Charts)

This video will be for beginners and intermediate users as well.

Meet Your Teacher

Teacher Profile Image

Thomas Fragale

Microsoft Certified Trainer - 2152801073


Class Ratings

Expectations Met?
  • Exceeded!
  • Yes
  • Somewhat
  • Not really
Reviews Archive

In October 2018, we updated our review system to improve the way we collect feedback. Below are the reviews written before that update.

Your creative journey starts here.

  • Unlimited access to every class
  • Supportive online creative community
  • Learn offline with Skillshare’s app

Why Join Skillshare?

Take award-winning Skillshare Original Classes

Each class has short lessons, hands-on projects

Your membership supports Skillshare teachers

Learn From Anywhere

Take classes on the go with the Skillshare app. Stream or download to watch on the plane, the subway, or wherever you learn best.



1. Excel Charts for beginners Tutorial Excel 2007 2010 2013 2016 Bar chart Pie Chart 2axis line combo: in today's video, I want to talk about how to make some charts in Microsoft Excel Now. In this video, I'm using Excel 2016 But many of the same techniques were working except 2013 Excel, 2010 and Excel 2007. So here's some great data to make a charge from now. What's really helpful here is that we have the column headings and we have the row headings , and that's going make a difference in our chart. You don't need those things to make a chart, but it sure is gonna help when we have the column. Headings in the row headings I'm gonna make several kind of charts in this video. Eso First of all, you're gonna highlight your data. So let's highlight starting and sell a three all the way over toe knife. I could have included the totals, but I'm just not included Totals for this one. Now, Um, I started and sell a three because knows how your first stroke contained your column headings and your first column contains your row headings. That's pretty much going to guarantee that charts can look as good as possible from here. We'll pick on the insert milieu of top and under the insert menu, you have your different chart types. Now this menu looks slightly different in Excel 2007 and Excel 2010. But the general theme is the same. So in this case, I'm gonna pick on the column chart first, and we'll do some more later on. And then we have even here we have our column charged a three D column, charged two bar charts and the three D bar charts. So you have lots of chart types, even from the screen, and I'm just gonna pick on the 1st 1 right here and right away. It makes 1/2 decent chart for us now, of course, we're going to have to make a lot of changes to that chart, but right from the gecko, it makes 1/2 decent chart. Now let's get go over some basic terminology. These numbers over here on the left hand side, that's called the Y Axis. Now, where's his January February march at the bottom here that's called the X Axis. This guy here, the very bottom is called the Legend, and the legend is going to show you the color and what that color represents. So knows how the row and column headings made its way into the chart, so that's why they were important. The next thing I would do is to move the chart. The move, the chart. I'm gonna move the mouse onto the chart under the background of the chart where my mouse is . It's gonna see chart area when it says chart area that I'm just going to pick it up and drive dragged over here so it's not in the way. Now I want to show you that if you change the data on your spreadsheet, the char will also change. So, for example, right now it's a sales and marketing and advertising, and you could see the chart says the same thing. So they all type in sales and down here it's his research and development, and I'll change that to our and D and knows how the chart changed as well. So when the change, the data on the spreadsheet, the trial will also change now, the next thing I like to do is let them eat that chart larger to make it easier to read, to make it larger I'm gonna click on the chart. Click right on it. Now, I'm gonna come over here on the corner and get this sizing handle. You can tell I'm on the sizing and no close your mass because of double our. I like to use the one in the corner, so it keeps it in proportion. So I'm gonna get the double our and stretch it out. And the tripe became larger, as we can say. So they make the chart larger. You're going to click on it Now, there's also sizing handle up here at the top on the sides at the bottom. But I want to use the one in the corner so we'll make it the double our and stretch it out and you could see it made it bigger. You might understand why I made it bigger when you turned 40 right, But, uh, you know, we'll see about that. Okay, so now we have a nice truck. Now let's start to modify our truck. I'm gonna click on the chart. When they click on the chart, you get two extra menus of top design and for men. Now, if you have Excel 2007 or Excel 2010. Then you get three extra millions up there. You get designed layout and format. Notice how I don't have the layup menu anymore in Excel 2013 let me show you what happened to it. So we used to have the layout menu, which used to have our chart options side to chart title and the The Axis title and things like that. Let me show you where they move that and accept 2013 that Excel 2016. So I wanna pick on the design menu, and then you come way over here on the right. I mean on the left and you pick on add chart element. And then we see what used to be under the layout menu. So if you're watching this and if you have except 2010 or Excel 2007 you'll have the layout menu and you'll find those same kind of choices except will be going across the screen on the ribbon here and accept 2013 and 16. You pick on the design menu and you took on add chart element, and then you see those items recycled is the chart options in the the really old version of Excel, they will call the chart options. All right, so I'm gonna click on my chart and that cause is that the two extra menus here? Design and format. Let's talk about the design menu. So, um, now, if you get this extra screen here, it is something that came with Excel 2013 and 60. In this case, we're just going to click away from the chart and then click on the chart again, and then we'll be fine. So first, let's start with the design menu. Now you have some quick layouts, and what that means is, we can these air preset formats. And if you go through middle, show that it's gonna add various options in there. So you might want to try some of the quick layouts and see if they could help you out. Ah, we can change the color scheme really quickly. All right, so we have various color schemes. You go through some of those and this had the preview. Mood is kicking in, and you could see what they might look like. Now, here we have the charts styles, so the chart styles are just preset formats with different color schemes as well. So you can see how they're changing your chart. You have some preset formats under your charts style, so you really get a great head start. But using the quick layouts, changing the color scheme or using the chart styles. So make sure you experiment with this, but I really want to show you how to customize your chart. So I let this one is called switch row and column right there knows. Right now my month names are on the X axis and my department names are on the legend. So if I come appear and if I'd pick on switch Raylan column, then knows how have flipped. Now the department names are on the X axis, and the must names are on the legend. So with that button right there, you get to have two different pictures of your data to different views. So I'll go back. And now you can see how the month names are on the X axis, and the department names are on the legend. Now, this next one could be very important for you. It's called select data. So a pecan slept data right there. Now, first of all, this window is going to appear and it's going to tell you where your charts coming from. So if I go into this spreadsheet and has a chart, one of the first things I'll do is up on select data to see where the tracks coming from. Now the next reason why this is important is let's say, next month you have more rows or more columns. In other words, you have more data. Well, then you would go in here and make sure you highlight the larger range, so the chart will reflect that, so that can be very important for you. First reason I go on this screen is to see where the date is coming from, and the second reason is maybe you have to have a larger range, so that will be included in the chart as well. I want a quick okay now knows over here on the design menu we have when it's called change chart type. By the way, if you are using Excel 2007 or Excel 2010 than these three choices right there will still be under the design menu. But to be on the left side of the design menu if you have, except 2010 or Excel 2007 but they're called the same thing. In this case, I'm gonna pick on change chart type and those how Excel has many try types to choose from. And in this video, we'll talk about some of these. Another really popular one is called a line chart. I'll pick on mine and I'll pick on one of this and you can see how the chart is now a line chart. So change your try type is not hard on the big unchanged chart type, and we'll pick on the column category and I'll go back to the one that we're on and I'll click on OK, all right, so you could see changing your try type is not difficult now. If you follow my mass up here on the right side of the design menu says Move, chart now that's quite alarming to move it to a different sheet. Sometimes you want the data on one sheet and the try on a separate sheet, so that allows me to move into a different sheet. As you can say now in this case I don't have to do. It was just an example. Now, even if you move your tried to a different sheet when you change, the data on the main sheet to try will also change. So that allows you to move the chart to a different sheet. I'm gonna pick on cancer with that. That was called move chart right here on the design menu. So now I'm gonna go through some of those chart options. So in this case, I want to scroll down a little bit and it'd make their try even bigger. Just stretched out with the sizing handles, you could say. Okay, good. So now I'm gonna pick on the design menu and I'll pick on add chart element. Remember, if you're using Excel 2007 or accept 2010 these will be under the layup menu and they'll be going across the river. But the called the same thing. If I didn't have a chart title, then I'll pick in the world. Try title there and I'll say above chart, that's the one I like. And you can see if you didn't have a try title before. Now it does say try title. So you type in whatever you want it to their small type in 2016 budget. If you're watching the recording of this, then I did record this, Nick. So in 2016 now, sometimes people will say, Well, can we make it so that it's gonna show the same title that you have on your spreadsheet up there? Let me show. You have to do that on the chart. You're going to click on the chart title now. What you do is you type in the equal sign to start a formula, and then you click on the cell, but that you want to reproduce. All right, so that was important. I typed in the equal sign that I clicked on this cell in this case, cell a one. I hit the enter key and now notice How might try. Title is the same as what, Since Cell A one. So that was a good trick right there. Now the next title that I would like to add is over here on this side. You've seen these before? It might say dollars or gallons or cases or something like that. That's called the Axis title So once again, I'll pick on the design menu. Then we'll come over here and we'll say, Add chart element and we'll say access title Now the primary horizontal will be at the bottom and the primary vertical be on the side. So I'll say primary, vertical and nose Over here it says access title. Well, I want that to say something better, So in this case, I'll type in dollars. So I would almost always add the Axis title on the side. And I would almost always add the chart title s. So now we know what the Trans talking about. It makes more sense now. A lot of times when I show people charts, they want to know how we can manage these numbers over here on the side that's called the Y Axis. And maybe we want to get rid of zeros, maybe wanted to get rid of the decimal places and cleaned it up a little bit. So what I'm gonna do is I'm gonna move my mouse to those numbers right there, and I'm gonna double click on that number. Now, when we double click anywhere on the chart, it's gonna give you this new menu. Now, if you have Excel 2010 or Excel 2007 the extra menu will be in the middle here. But except 2013 and 16 extra menu is on the side, so this gives you a lot more flexibility. You can double click anywhere on your chart, and you get this new menu for much. You have a lot more choices. So, for example, if I want to change that toe, maybe go to 60,000 or 100,000 or something like that, that over here I would change the minimum or the maximum numbers right there. Now here it's breaking it down into every 5000. As you can see eso that's called the major units because, he says $5000 you can adjust that the minor units would apply if you have the minor grid lines on which we could do later on. But that will only show up if you have the minor grid lines on your had. The major good lines. This is 5000 and you could see every line is every $5000 so we can change that as well. Now here's a really important one overhears has display units. I'm gonna click on that. Pull down so you can show your numbers in hundreds, thousands, tens of thousands, millions, billions, trillions. Okay, even trillions were there. Let's try thousands and let's see what that does notice right away That took off a lot of zeros. And now it's just this thousands there, so that made it a little bit easier to read. So we, um we came into the screen that's called format access. I got there by double clicking on those numbers in the side. And then from here, I changed the display units to say thousands, as you can see. And there's other choice is there obviously. Now, what about those decile places? Well, I'm loco headed pick on this word that's called Number, and then you have your classic number formatting. So I'm gonna go ahead and change that to a zero. I don't really need to see the the pennies here on a chart like that. So I make the dust all place zero and then you have your other formats that you're usedto now the thousands separator. If you need it, that that will be the comma between your thousands and your millions. And then you can show your negative numbers either with a minus sign or in red or in parentheses or red and parentheses. So check with your a kind department and asking Had I want to see their negative numbers than what they're going to tell you is they don't want to negative numbers at all, right? But when they do show, how should it is? Display? So you have a lot more choices here in the screen. I'm gonna make sure that we have ah number format with zero decimal places. And then I'm gonna close this extra window with the X over here and now we can see it's his thousands there. I covered a lot of the zeros, and they're also whole numbers so that it got rid of the decimal places as well. So it looks a lot cleaner Now, Now, let's continue on talking about some of the chart options. So you see this guy down here? The bond. This is called the Legend. The legend is going to show you the color and what that color represents. So some people like to have that on the side or at the top or maybe not even sure that at all. So I'll pick on the design menu. Well, come way over here. I will say, add a chart element and then we'll pick on legends. Now, if you pick on none, it's not gonna be there at all. But that is how I can put it on the right, the top, the left or the bottom of the chart. So I'm gonna keep it on the bottom. I just want to show that we do have somewhere options for the legend. Now the next one is something that people like a lot they might say. Can you put the numbers on each individual bar that's called a data label? So again, I'm gonna pick on the design menu and we'll pick on add chart element and we'll pick on data label. Now. I like the one that's called outside end, but you can always try the different ones. So I put on the outside end and you could see how that put the numbers on each individual bar just like that. Now, these air showing the decimal places, you can get rid of the decimal places in the same way that we did before. So in this case, I'm gonna pick on one of those numbers. Notice how all of the numbers for that same color are now selected. So, actually, what I could do is I'm gonna click away from that for a second. Look over here. Then I'll double click on the number. If we double click on the number, then you're gonna get that extra windows we could see again. And in this case, I'm gonna pick on the three bars. Rights are and I put in the number category and again, Ah, committees number format and then changed a number of vessel places. But these numbers on the side are on the top of the bars are called the legend. I mean, the data label. All right, so now what if you didn't want those to be there anymore than I'll pick on add chart element data label and I'll say none and they go away. So adding things you try, it's just Azizi is taking things away, as we can see now. Sometimes when I do the data label, somebody will say, Well, can I make him appear on the inside of the bar? Kind of on the side like that. So let's see what we could do about that. I'm gonna say add chart element data label and I'll say outside at first of all, say inside end. And if you notice the numbers are now on the inside of the bar Now I want to make those first of all different colors. So that way we could read them easier. So I'm gonna click on that number and again knows how all of the numbers for the same color are now selected. And then there's numerous ways we can change that. Ah, pick in the home menu. And I'm just gonna change the font color to be white or maybe a lighter car. You know that. They're gonna stand out. Good. Now watch how we can change those to be on the side. Now, if this extra menu isn't already open, here's another way to open it. Those how the my numbers are now selected in this case. I'm gonna pick on the format menu format, then will come way over here on the left. I will pick on format selection and knows how that's going to open up the extra we knew as well so I could either double click on the part of the chart or you can pick on the part of Try and you pick on the format and then you say format selection and those air both ways to open up the extra window over here. So watch what we're gonna dio. Here's his format data labels, and I'm gonna pick on this guy right here. Size and properties is what it says. Then we're going to expand where it says a line that and then we're gonna change the text direction to be, rotate all text 90 degrees or, in my case, will say to 70. And that's what that did. It actually changed the text. So it is vertical. And because I made it Wait, Now it stands at really quickly. So watch again. I'm gonna click on one of the numbers from one of the bars that shows all of the numbers for that color bar all the way across is you can see now if that if this menu on the side was not open, then I'll pick in the format menu and I'll pick on format selection over there on the left . In this case, we have the extra screen. So now critical in the sky right over here. This is size and properties. Then we'll Ah, If alignment was not ever to expand, it will expand the alignment. And we're going to go ahead and change the text direction to, say vertical, rotate all tax to 70 where you can also make it stacked like that. Some people like it that way. So let's try stacked you for this one, and you could see how the numbers are now stacked. Maybe maybe the old was better. So make it right too. And now you can see the numbers are rotated. If I want to change the color of this, that's just normal for Manning up going home and we'll go back to the white color and they stand out maybe a little bit better than all right. And you would do that for each of the numbers on the different bars. So you have the vertical numbers there. I'm gonna close out of this window on the side. Now, here's another way to show the numbers on the chart Now, a lot of times to select the entire chart, I'm gonna go ahead and pick on the the background of the chart. Where's it's Chart area? I'm gonna click right there to select the entire chart. From here. I'll pick on the design menu and I'm gonna say add chart element. And then I pick on something that's called the data table, and then I pick in the second choice right there. That's you. What that does for us knows how that put the numbers below the chart. So maybe like it that way. That's called the data table here. It might be a little bit too busy s so I can take that away. I'll say, add shark element did a table and I'll say none. And you could see that makes that go away. So knows how those numbers down at the bottom. That's called the data table if you like this. But I'm just gonna take that away by saying the word nine and we're back to normal here, all right, eso have so many great choices with your charts. Do you see the lines on the background of the chart? That's called grid lines grid lines. So you have control over those as well. I'll say add chart element grid lines and I already have the horizontal lines. I would like to have the vertical lines, so I'm gonna do Ah, primary, major vertical. And now you can see I have the vertical lines there as well. So, um, if you want to, you can turn the lines off completely. USA ad sharp element grid lines. And then you just uncheck both of this so they're not selected anymore. So those your lines in your tribe now, a lot of people like this next one. It's called the Trend line. The trend line is going to connect the dots between the Siri's and share the trend more clearly. So I'm to see add chart element trend line, and then I'm gonna pick on linear, and that's gonna be a straight line. And then I pick my syriza pick on the computer, Siri's and click OK, and now you can see how we have the straight line between this Siri's that's called a trend line. Now we can do something special with the trend line. We can make you do a projection onto the future, so I'm just going to go ahead and go right to that lines here where my mouse is I'm right on the line and I'll double click on it. And that, once again, is going to open up the extra menu on the side. So those houses format trendline. So all these choices air just about that straight line. There's so many things you could do within these formats screens when you double click on the chart. Or like we said before the format selection. Now that is what it says down here, it says forecast forward or forecast backward. So I'm gonna change that zero right there to number three. So when we say forecast forward, it changed it to or the number three and I'm gonna go ahead and close that window and now knows what happened that actually made their trend. I go into the future. So that was a pretty nice When they know about in this case, I'm gonna double click on the trend mine. DoubleClick that opens up the extra screen over here achieved the forecast forward to, say, three, which in our Kays happen to be three months now. These might be helpful for you. If I think displayed the equation or the spread the are square, then let's see what happened there and you could see it gives you some extra image information about that line as well. So maybe that was helpful for you as well. Now, if I don't want that line to be there anymore, I'm gonna go ahead and click on it. And then I hit my delete key on my keyboard, and then I'll make that go away So you're never set in stone. Here. You can always go back and forth with the different options of your charts. Now, let me show you some more of these. I'll pick on, add sharp element. Now remember, you have to click on the chart first, and then you'll have the design menu in the format menu. If I click away from the chart, no said there's are not there anymore. So I'm gonna click on my chart, and then I pick on the design menu and I'll say, add chart Element now knows how couple them are not available. Those might be available when you have a line chart or other kinds of charts. In this case, I'm gonna Goto wears his error bars and then let's try the standard error and see what that does. And those might be ranges of acceptable, acceptable numbers. So it shows an upper limit. And if you look really closely, it'll show, Ah, lower limit. So those were like acceptable values except the world ranges. So I'm gonna turn that off again. I'll say, add chart, element the error bar and I'll say none. So you have a lot of flexibility with your charts, as you can see, and we used to call those the chart options. Now you pick on the design menu of the chart and you pick on add chart element. Now, in this case, I'm gonna turn off the data label or, you know what? Let's take them all vertical, so it looks a little bit better there. So I'm gonna click on the blue one, the blue number and those how they're all selected. So first of all, I make those white. Now watch what I'll do again. I'll go back to the design menu, but go back to the format menu and I'll pick on format selection. And remember how we did that a couple minutes ago. I'm gonna go back into the size and, uh, alignment and will change the text direction. This to be voted all text to 70. Good Now, just do the same kind of thing for Let's see if the format painter works. I'm not sure if you're willing up, I'll take a shot. So it took on that number pic on the format menu. I mean, the home menu, and I'll do the format painter right that you might be familiar with and see if we could make it go with those numbers as well. So that doesn't seem to be working right now, but I'll just do it the old fashioned way, so I click on that number. First of all, we'll change the the text direction Toby to 70 and you know what I'm gonna do? Want to make it wait and we'll do that for the other numbers as well Text direction. And then we'll make that way. It doesn't let me pick more than one. By the way, if I have in my shift key and try to be more than one at the same time, it's not. Let me do that. Eso I'll click on the number and do text direction to 70 and we'll make that one wait a swell. So now all of the bars have the numbers and have the data labels and their vertical. All right, so we have a nice looking chart. Now, I'm gonna go in close that window. Now, if you want additional text on your chart, maybe can add data label Seth for the insert menu offensive insert, then maybe can have pictures to the chart show. I've seen people. You shapes the text boxes. All this could be added right to your chart. Now, I'm gonna go ahead and save my spreadsheet. Now, a lot of times when I show people charts, they'll say, Well, can we use this chart in Excel? But also used that same chart in word or in Power Point or a different program? And the answer is yes. So what you do is you make your chart in excel, and then you're gonna move your mass towards his chart area right there and when it click there, So that selects the entire chart, which is very important for this next step. So if this guy move ever here and move your master, where's this chart area? When it does say chart area, you click there and that selects the entire truck from here. I'll just do a normal copy. So when I right click on the chart and I'll pick on copy now you're going to go to a different program. Maybe it's word or PowerPoint or something like that. So I'm going to go into Power Point. That's the one that many people use. So I pick up my start menu, of course. And then I have Windows 10 here. So a pecan APS and I'll get a power point. Good. Now the technique and I'm about to show you and Power Point will work the exact same way in a word or physio our outlook or project or any of the other Microsoft programs. Really, it'll work the same way. All right, so we're gonna open up power point and just give me a second. So now, now, Power Point is on the screen as well as we can say, Okay, so, uh, in excel, I did a copy here. I'm not just going to a paste. I'm going to a paste special and I'll show you why. So pick on the home menu, and when I pick on the pull down where it's his paste and then I'll pick on Paste special. And then we get this window. Now there's a couple reasons why I had to do pay special instead of just normal paste. First of all, the charts gonna look better. It really well, it'll look better when you do a pay special second. But look at this choice is called Paste Link. That means if the that means if the chart changes in Excel, it will also change it here at the same time. So if you want that to be linked together, become paste link. Now make sure you become the one that's called Microsoft Excel chart object, because that's the one that really works the best. Sometimes there's more than one in the middle you put in the one that's called Microsoft Excel Chart object, and I'll click on OK, here we are in power pointing or whatever program that you're in and those how there is the chart, and it looks pretty good now here in Power Point. That's really just a picture, so I can resize that to fit the slide better looks pretty good because we did a pay special and then a paste link Now let's see what paste link. Thus, that means if I change it back and excel, it's going to change it here at the same time. So let's go back to excel now. And there's the child. Okay, good. Now I'm gonna make an obvious change of my Excel spreadsheet. So I'm gonna pick in the company, budget the track title up there and knows how we get the format menu. Now, the format menu is where we can change that specific part of the chart so I could change the fill, which is the background color, the outline, which is the border. We continues the text areas. Now. I like the extinguisher called shape styles. He's a preset formats and I'll pick on the red shapes style. You could see my company budget became red. I'm gonna come over here and pick on the word thousands and make that read, and I'll pick on their dollars and make that read. Good. So those were pretty obvious changes. So my point there is you can pick anywhere on the chart and then pick on the format menu to do further For many years, we can say, and I'm gonna go ahead and save that. Now let's see if the chart changed and power point as well. So I'm gonna go back to Power Point on the bottom of my window. Peritus There's the chart and you can see that it did change. It changed because we did a copy from Excel. Then we came over here and he said, Paste special and then paste link. Now, even if the Power Point presentation wasn't opened the next time you open up, it'll have the newest version of the chart because we've had pay special and then paste link. By the way that I work between any two Microsoft programs, we can go from word the Power Point, Power Point to Excel, Excel, Power Point or any combination so you can copy from one, go to the other program and said, Please special paste link. So that means if you change one, you change the other. So where we found that was under the home menu. Then we put in the pull downwards his paste, and then we said, paste special as we can see, and I said, paste blank and I make sure you pick the one. This is Microsoft Excel chart, object or if you're copying any kind of data that might say Microsoft to sell, you know, some other kind of data. But that's the one that you always wanted packed when this is object at the end. Okay, so that's what we're going to talk about with tired from here in this session. Um, probably make other videos about power point specifically later on. So I'm gonna go ahead and minimize power point. And now, back to excel. Now, I want to show you some some other chart types. So in this case will make something that's called a spark line. A spark line is a miniature chart, and it actually fits in one cell. So a lot of people are like and use quite a bit because the spark line doesn't take up a whole lot of room. And yet we can We can still show that the data graphically. So I'm gonna take a blank cell right now pick on l four and then from here, I'll pick on the insert menu in certain, and I'm gonna come over here and I'll pick on the notice how we have the spark line group right there. So somewhere on the insert menu. Look for the group that says Spark Line just like that. And then I pick in their columns Now, By the way, the spark lines are not available. In Excel 2007 they started in Excel 2010. Now it's asking for the data range. The data range for that row is from C four over toe I for see for Toe I for and then the location range is where the spark line will appear and I'm gonna prevent and sell l for and I'm gonna click on OK, that's a spark line. It's just a miniature chart that fits in one cell. Now what's interesting about that is if the numbers change, want to change this to 12,000 right there and you can see how the spark Line updated as well. So knows how it was going straight up. Now it's going up and down because it changed the numbers. Now let's go ahead and click on that cell, and I'm gonna go ahead and get the black cross and drag it down so we can have the spark line on all the other rays as well. So each road now, is there an individual track? People relate the spark lines for that reason it does doesn't take up whole other room. But now I have a tried for each individual round. Here's how you could do some formatting with your spark line. I'm gonna go in and click on that chart, and I'm gonna go ahead and pick on the design menu. Now, you only get that design menu when you click on this spark climb. From here, we have different formatting options. You can change colors and things like this, so I'm gonna say high point and low point. Now, the low numbers are very hard to see. A little closer, you can see him, but clearly the high numbers became a different color. So when you pick on your spark line, you get the design menu from there, you could do further formatting. But that's all that it Really? Yes. I'm gonna do this for you again. So in this case, uh, good to the bottom of columns. See, we're gonna sell C 10 and I'll see insert and then sparkling. Those health has sparkling. Sure they're not picking away. That's called column. Now, this time the data range will be see for to see nine and then the location is going to be C 10 for the spark line. And then there, this so people will use these at the bottom of the column or at the end of the row, the graphically show that data. And then I have the insert. I mean, I have the design menu former check, and make some different formatting changes. As we can say, great new addition to excel. That's called a spark line. Now I'm going to get rid of the one that we just did over here. So I'm gonna undo that a couple times until that one won't be there anymore. And now it's gone. Okay, so here we made a column chart. No. If I picked them that chart, then you can pick on the design menu, and then here you have changed chart type, and then you can choose from any chart types as well. Now, when I teach this, um, my cheeses in a public format, a lot of people will ask me, Let's say you really like the colors that you chose, and you like the fact that the data labels are vertical like that. You like the legend on the bottom. Everything is looking good. Can we save this for use in future charts? So I'm gonna go ahead and save this spreadsheet. Now, let me show you how you dio make a chart template. You're gonna move your mouse onto your chart and you're right. Click on it when you right click on it. Notice how it says save as template. So I'm gonna do that now, when you save it as a template, make sure you don't change the folder name up there. Leave it right on that folder name. That's where it's gonna look for them. And you want to give these a good knee so you could have as many of the chart Temple says you need. So you want to make sure you give him a good name, so I'll call this one, call this one the Amazon, and I pick on safe eso Let me show you how you would use that. Now, in the future chart, I'm gonna go to a different spreadsheet. I pick on file open, and if you're a click on browse here and I go to a different spreadsheet, that's called consolidate example, by the way, to get my files that they used for my classes. For these videos, you send me an email. Teoh, get class files at gmail dot com. O even spell it out here the class files at gmail dot com And then it will give you instructions on how to down the file that they use for my videos. Could make that larger for you. Eso If you send the email to this email address, then it will show you how to get the files for the class. I want to make sure you saw that. Now here's a nice Excel spreadsheet. It's pretty similar, obviously. Right? So I want to highlight the data starting from Sell a three all the way to sell nine and I want it Now make a chart using the same temple that were just made. So I'm gonna pick on the insert menu in sir, and what you do is should pick