Easy-to-follow video tutorials help you learn software, creative, and business skills.Become a member
Excel is create charts. Before we begin creating charts, we should take a look at the chart terminology and understand the components of a chart. If you'll browse to your Student Files, you'll find in section 10 Charts, a spreadsheet called Quarterly_Sales; yet another version. There we go. Now there's a quick and easy way to make a chart from any spreadsheet. Select the applicable data, in this case I only want the titles and the values within my chart and press the F 11 key, and voila, we have a chart. Now that was fast and easy. Let's go over the terminology in this chart. The first thing you need to know is the Category Axis. The Category Axis describes the main categories that we're comparing within this chart. Next we have the Value Axis. The Value Axis can have labels or various scales that describe how we're comparing this chart.
Here we have the scale values, so you know exactly what the differences are, what's being measured. In this case it's dollars and the units are incremented by 10,000. Over here we have our legend. This describes the color scheme for the bar chart that we're looking at and you can follow exactly which color bar describes which division. A chart may also have a title; this one doesn't. We can add that later. Gridlines. Gridlines can be horizontal and vertical. By default, this one came up as horizontal only. The Chart Area. The Chart Area is this entire window that appears on this chart tab. And you should also note that the Chart tab has been added to our workbook and is sitting on top of the various sheets that we have in this workbook. And the Plot Area, which is represented by this gray box. Everything you see inside the Plot Area is your actual chart. Those are the basic components of any chart regardless of the style, and be aware there are many, many different styles of charts that you can use. Based on the data that you're trying to present, different charts may be applicable.
Get unlimited access to all courses for just $25/month.Become a member
82 Video lessons · 69914 Viewers
80 Video lessons · 127346 Viewers
52 Video lessons · 62321 Viewers
59 Video lessons · 48011 Viewers
Access exercise files from a button right under the course name.
Search within course videos and transcripts, and jump right to the results.
Remove icons showing you already watched videos if you want to start over.
Make the video wide, narrow, full-screen, or pop the player out of the page into its own window.
Click on text in the transcript to jump to that spot in the video. As the video plays, the relevant spot in the transcript will be highlighted.
Your file was successfully uploaded.