Excel Charts 2019 - Preview

Microsoft Excel Charts 2019 Excel Charts 2019 - Visualize your data by working with many chart types in Excel 2019 / Office 365
2 minutes
Share the link to this page
Copied
  Completed
This will show how to get a chart started.

Transcript

So, this data that we're looking at will make a grid chart. And I'll show you why. Because it has the column headings, and it has the row headings. Now you don't need those things to make a chart, but it sure is going to make the traffic a whole lot better when you have the column headings and the row headings. Now sometimes during the session, I'll make my mouse do that. So you can find my mouse that way as well.

All right, and you can see I do have the newest version of Excel. So if you have anything from Excel 2013 onward, then the screen should be pretty similar to what you have. So we'll make this chart and then we have other charts to make as well. So first thing you want to do is you always want to highlight your data. So I'm going to click on cell a three, and I'm going to highlight from a three over I nine. Now the reason I am starting the cell a three if you notice, my first row contains my column headers, and my first column contains my row headers.

That'll pretty much guarantee that the charts gonna look as good as possible. All right. So at this point, let's start our first trip. Most of your charts can be found under the Insert menu. So I'll click on Insert. And then you have your chart types over here.

Now, they have added some new chart types recently. And maybe towards the end of the session, I'll show you some of the new chart types. But let's go back to a classic, I'm going to move the mouse there and it says insert column or a bar chart. And then even if I click on that, there's different varieties. So there's many different types of chart here in Excel, and they're always adding more and more. So when you click on the first one.

And just like that, it makes it pretty decent chart for you. So if you highlight the data, the correct way to try it's gonna look pretty good. Now of course, we'll be able to enhance that chart, but it's really not that bad right from the beginning, if you had it to chart the proper way. Now let's go over some of the chart terminology. The numbers on the left hand side that's called the y axis Whereas his January, February and March is called the x axis. This guy over here is called the legend.

The the lines going across the chart that's called the gridlines. And we even have a chart title. Now of course, we'll be able to enhance that chart, but it's really not that bad from the beginning. So the numbers on the left is called the y axis down here where it says January February March, that's called the x axis. This is called the legend. The horizontal lines are called the gridlines.

And then we have to track title. Now if you notice it, put the chart right on top of the data so I would never leave it though. I like to move that chart. To move that chart. You're going to move your mouse onto your chart so that your masses chart area like that. Usually in the background of the chart, it'll say chart area.

So when it does say chart area, just kind of pick it up and drag it

Sign Up

Share

Share with friends, get 20% off
Invite your friends to LearnDesk learning marketplace. For each purchase they make, you get 20% off (upto $10) on your next purchase.