WEBVTT 1 00:00:01.620 --> 00:00:07.890 William Rosener: hello, this is Dr bill roesner and this instructional video we learned about charts using Microsoft excel. 2 00:00:08.429 --> 00:00:17.850 William Rosener: The chart is often called a graph it's a visual representation of data from a worksheet that can bring more understanding to the data than just looking at the numbers. 3 00:00:18.240 --> 00:00:30.750 William Rosener: The chart is a powerful tool that allows you to visually display data in a variety of different formats, which is a bar a calm py line stack area donut scattered surface radar charts etc. 4 00:00:31.440 --> 00:00:40.890 William Rosener: And this particular video will be actually this assignment will be created in a line chart stacked area and, finally, a pie chart. 5 00:00:41.580 --> 00:00:54.780 William Rosener: know that we don't know what we're doing let's go ahead and get started there so in the same area as you found a link to this video, you should also find some data, if you want you to type it in, or you said a few seconds they're like copying and pasting. 6 00:00:55.950 --> 00:01:05.880 William Rosener: So the first one we're going to do is we're going to go ahead and create a line chart to do that and take a look here, maybe one one more time i'll actually put these on their own sheets. 7 00:01:06.690 --> 00:01:13.770 William Rosener: The line chart and the stacked area are going to be plot in all three tablets laptops. 8 00:01:14.610 --> 00:01:22.050 William Rosener: And desktops their red sheet for this is going to be my pie chart on i'm going to do plot in that one is the tablets. 9 00:01:22.950 --> 00:01:32.370 William Rosener: So anyway, I take a look at so i've got my data entered i'm going to go and highlight my data repress right on insert them to come right over here, I could go do. 10 00:01:32.970 --> 00:01:46.020 William Rosener: Either I could press on that down arrow and choose and sort of line chart ranking right over here to recommend the charts I do that i'm going to highlight this one, which is a line chart second one down there and press okay. 11 00:01:47.340 --> 00:01:52.560 William Rosener: What i'm going to do to make it easier and kind of recommending that you didn't same thing it's the hidden copy that. 12 00:01:53.580 --> 00:02:04.470 William Rosener: And i'm going to have already get you'd press the plus sign accredit new tab i'm gonna go ahead and press right here and sheet to and paste this open get this Nice and big and much easier to see that. 13 00:02:06.720 --> 00:02:12.240 William Rosener: Okay, so probably the first thing i'm do is come right up here, where it says chart title and i'm the type of. 14 00:02:13.800 --> 00:02:14.340 William Rosener: Product. 15 00:02:17.850 --> 00:02:27.420 William Rosener: Trends I month and, while i'm here to tell you what them when selecting stuff in this case I could carefully try and select that. 16 00:02:27.930 --> 00:02:40.440 William Rosener: Or, I can do is position my cursor anywhere in the metal hit control a to select all I think can come right up here and you make that ball and i'm going to go to increase that size to say, maybe 20. 17 00:02:41.640 --> 00:02:51.120 William Rosener: Okay, I want this really easy to read, so i'm going to increase the size of these some highlights the numbers over here on the left and repeat that i'm going to go with 16. 18 00:02:52.410 --> 00:03:04.080 William Rosener: And i'm going to highlights months repeat that and we come up here and choose 16 for the font size and the same thing on either desktops laptops the products. 19 00:03:08.490 --> 00:03:16.740 William Rosener: Okay, so that's what we got so far this take a look at here was what we need to do so we've kind of changed the chart title. 20 00:03:17.490 --> 00:03:26.670 William Rosener: increase the font size now what we're gonna do is we're going to add change the color of the plot area in the middle, will make one of these different color so it stands out. 21 00:03:28.260 --> 00:03:37.410 William Rosener: So okay to change the color of the plot area I could right click here, I believe I could right click somewhere click once on the right click there. 22 00:03:37.740 --> 00:03:47.730 William Rosener: I can format it or I can just simply Double Click it looks like the flop format plot area is going to appear and i'm going to do is choose a solid area just to get some color. 23 00:03:48.810 --> 00:03:50.940 William Rosener: Next, one to do is highlight one of these. 24 00:03:51.960 --> 00:03:58.560 William Rosener: And if I start clicking then it's going to be changing the color one point, so I just want to click once that's going to highlight the entire line. 25 00:04:01.020 --> 00:04:10.530 William Rosener: i'm gonna choose solid line and i'm going to go with a red, and it really made me with this one to jump out so i'm going to go ahead and increase some the width of that. 26 00:04:12.000 --> 00:04:18.300 William Rosener: In one last step there, I really want to make this like it when there's a border around my chart so i'm gonna highlight the chart. 27 00:04:19.770 --> 00:04:33.660 William Rosener: suck at the whole chart selected and come to border this case i'm going to choose the black and maybe i'll go with I can come in and use the parallels or maybe just put in, say, three to create a nice thick mortar on the chart. 28 00:04:35.130 --> 00:04:39.660 William Rosener: Okay i'm gonna call that one finished now take a look at the next one. 29 00:04:41.070 --> 00:04:45.270 William Rosener: This is going to be a stacked area chart let's get started on that one. 30 00:04:46.560 --> 00:04:48.600 William Rosener: So i'm gonna come back here to sheet one. 31 00:04:49.890 --> 00:05:02.280 William Rosener: Again, this one is gonna chart all of our data so highlight all the data we can write up here to insert we can right underneath recommended charts and I can see, this one is right here. 32 00:05:03.510 --> 00:05:07.710 William Rosener: A cluster I mean it's a stacked area, and let me okay. 33 00:05:09.270 --> 00:05:10.980 William Rosener: i'm gonna go ahead and drag this one down. 34 00:05:12.210 --> 00:05:23.430 William Rosener: I really want to do is simply copy that one, I want to pay someone on its own sheet paste to make it easier for you guys to see you and just I like working with larger graphs are. 35 00:05:24.870 --> 00:05:30.750 William Rosener: Good maybe even close that momentarily so probably the first thing i'm gonna do is just like we did earlier and go ahead and type in. 36 00:05:32.850 --> 00:05:33.450 William Rosener: Product. 37 00:05:34.470 --> 00:05:36.060 William Rosener: Trends I month. 38 00:05:37.890 --> 00:05:41.010 William Rosener: increase the font size, they make that bold. 39 00:05:43.170 --> 00:05:46.800 William Rosener: Let me come along in increase the font size. 40 00:05:53.040 --> 00:05:54.030 William Rosener: over here as well. 41 00:06:02.790 --> 00:06:12.330 William Rosener: Okay, and there we go a couple of changes here when you're going to do is take a look, I want to add some color over the whole chart but if the border. 42 00:06:12.750 --> 00:06:22.470 William Rosener: I mean we rotate so let's go ahead and rotate the months someone come right back here in my original going to Double Click here actually I could right click right on the line. 43 00:06:22.980 --> 00:06:32.940 William Rosener: and get to a format chart area I could choose phil solid phil and I don't really care what color you want let's do at walmart here. 44 00:06:33.570 --> 00:06:40.560 William Rosener: it's going to choose solid one black and maybe i'll make a this one, three, as well. 45 00:06:41.340 --> 00:06:59.820 William Rosener: Okay, one last change and change here let's go ahead and rotate the months here just another little bit at a slight angle, and to do that I could press right up here, size and properties, I could actually look these completely vertically, or I can come to a custom angle. 46 00:07:01.530 --> 00:07:02.670 William Rosener: and 47 00:07:05.100 --> 00:07:15.780 William Rosener: i'll do i'll stop when you stop at 30 degrees wherever you went there Okay, I think that one's looking good as well, so we got one last one i'm actually going to challenge you a little bit on this one. 48 00:07:16.350 --> 00:07:29.100 William Rosener: So the last room be created is a pie chart the notices when we're only going to be we've got several pieces of data there with laptops and desktops the world and before charting the tablets. 49 00:07:30.270 --> 00:07:32.370 William Rosener: So we'll come back here to sheet one. 50 00:07:33.480 --> 00:07:41.070 William Rosener: So in this case i'm going to highlight the month i'm going to hold the control button down all the control button down and get just tablets. 51 00:07:42.570 --> 00:07:44.520 William Rosener: Then i'm going to come along and insert. 52 00:07:45.990 --> 00:07:52.470 William Rosener: It right here's my little chart and i'm gonna choose a 3D pie chart and i'm going to drag that one on below. 53 00:07:55.050 --> 00:08:00.180 William Rosener: Now what i'm gonna do is copy this and paste it on she formed. 54 00:08:01.200 --> 00:08:02.760 William Rosener: And there we go. 55 00:08:04.110 --> 00:08:09.780 William Rosener: Okay i'm gonna let you guys have it shouldn't be too hard, but let's go ahead and now let's see what we cannot do here with this one. 56 00:08:10.320 --> 00:08:25.800 William Rosener: You don't want to do about three things so if we take a look here at the finished one i've got a ceiling get a nice thick border around the outside and add some color other than white, I take a look right now I don't really have a border and that's white so it's going to be step one. 57 00:08:26.820 --> 00:08:35.700 William Rosener: Then we're going to go ahead and add both the data labels and the category names some they would be at so I came back here to. 58 00:08:37.230 --> 00:08:41.340 William Rosener: sheet one came back up here here was may it was at. 59 00:08:43.230 --> 00:08:52.110 William Rosener: So when we come back here, to see if you can get the month and the amount and how many products are sold during that month so it's going to be two. 60 00:08:52.620 --> 00:08:59.970 William Rosener: And then the third thing is see if you can split, these are break these apart just creating a little gap between the various pieces there. 61 00:09:00.420 --> 00:09:10.200 William Rosener: And if you really want to challenge yourself see if you can get I think in my case, right now, over here on the Left was my larger area let's see if we can get. 62 00:09:11.160 --> 00:09:18.420 William Rosener: May over there kind of more towards the right, you know I think you'll be able to do it to start clicking right clicking maybe. 63 00:09:18.870 --> 00:09:33.870 William Rosener: If you get online a little bit and look, but I think you should go to handle this one as well, well, hopefully in this video, we can learn a little bit about how easy it is to create charts visual representations of data using Microsoft excel or catch the next video thanks.