Oh, welcome back. In this video, you'll learn how to create a chart using Microsoft Excel.
In particular, will make sure you can add a title to the chart a gradient film will come from white town the plume
Take a look at the axis here and we'll see if we can rotate this it's growing vertically and then take a look at the scale or see if we can adjust as they've been incremental six
Well, now that we know what we want to create. Let's go ahead and get started some stuff from scratch with this and come over here.
And open up Microsoft Excel here if I want, I can double click on one of these, just to get these these tabs appear for you double click on them will expand these various icons are the features there.
Okay. So I'll start at the very top, I'm gonna come and selves be one another type of spring.
In they'll just go ahead and highlight this entire document is a little bit larger font size here.
Spring, summer.
Winter.
This point, I can go ahead and type in sales.
Profits then I'll go ahead and enter some values 2520 3010 3510 in 45
Okay if I want. I could go ahead and center this information that probably want to want to do is some mixture I format this as currency. So the highlight this data.
Them to come up here and formatted as currency. Okay, ready to create our chart at this one I'm going to highlight all of this data and they're going to come up here to insert common across on the icon right here.
And I'm gonna go ahead and choose a 3D clustered column chart. And there we go. Okay, so we're beginning to take place here. Maybe we'll start a persona change the title. So to do that over your head, double click here on the title, you know, type in x, y, z.
Incorporated.
And millions of dollars.
If you wanted to you could actually have entered a hard to turn here to place that on it, someone more which you can even do is highlight Justin millions of dollars can make that font size, even a little bit less.
Than the rest of it.
Okay, so take a look at our title some point we get sales and profit over here to see if we can get the spring, summer, fall and winter going vertically. To do that, I'm gonna go and highlight the spring, summer and fall right click
Or men axis I can come up here and choose texts alignment and rather go horizontal. I'm going to rotate all Tex 90 degrees.
Okay if I want to move sales and profit, I can just grab that and move it on up here and resize that
Okay, so let's take a look here. One more time. Look at sales profit off to the right. We've got the tax.
Me dad are greeted film, but also notice over here. And what this indicates that save six as opposed to select the default nigga was five. So I'm gonna go ahead and I right click on this format access
And rather than the unit Spina commits, have fun. I want to simply choose next year. Maybe I'll go ahead and stretch this out and actually wish I could increase the font size on everything here. Let's go with maybe
This actually could be maybe a little bit smaller.
Okay, one last thing, actually this thing. Same thing here is some
I can do an on screen there.
Okay, as far as the gradient, though, I'm gonna highlight it, I can choose right click Format chart area. It's already open here. I'm gonna go ahead and choose a created film. And I'll tell you what, maybe I'll change this to white initially
Okay, so now we're going from white to white. I want to change the colors here. I can go ahead and press on that sugar color want if the one on the left to the right. Actually, I can even add colors in the middle. So if I want to go from white
tailed deer red, white and blue. So I'll start off with the Red, White the last minute change to blue. So I can go for red, white and blue. Let me go ahead and
Current more closely match the Simon behind remove that one. I'm going to highlight the first one I'm going to send that one to a white hot last one that set to blow.
There's some other options here. I'm gonna do or linear, you can do a radio, we're kind of started the middle and work our way out. We'll go with linear here's even some defaults and then the direction I can specify whether I want to start at the top and go down, or vice versa.
Okay, we're getting pretty close there one little thing here is I notice these are in red. I want to chase that I can go ahead and highlight just click on them.
Come right over here and change the color maybe to something like red. I think I'm gonna call that good. So take a look here. Here's kind of what we're trying to create something along those lines.
I wanted to maybe I like this and get a nice, darker, darker black
Okay.
That looks like. Okay, there we go. Okay, so hopefully this video you'll learn how to create a chart using Microsoft Excel.
Few things that we worked on is we changed the Texas with vertically as opposed to horizontally showed you how to adjust the scale. So go it's increments of five to finally a creative block kitchen next video. Thank you.