As you slide the mouse over one of the chart elements (Chart Area, Plot, area, etc.), an identifier pops up to remind you of that element's name. This feature facilitates learning the names of these different elements - you'll see these terms used in instructional material and in the ribbon menu system.
- View Offline
- [Voiceover] There are certain terms that we use as we work with charts, and they refer to different portions of a chart. You'll see these terms automatically as you move the mouse around a chart. On this worksheet here called Chart Data, and we're in the workbook Chapter 2 Chart Concepts, there's a chart to the right of the data, a line chart, and as I slide the mouse into the upper corner here, it says Chart Area. The outer area of a chart is called chart area, and anytime you slide the mouse around that area or just point to it, you'll see that term. Pie chart to the right also has an outer chart area, as do all these other charts.
The inner area, the one that typically holds the lines that we see on a line chart, these are called grid lines actually, and also on a pie chart, that's called the plot area. If you happen to point to one of the lines, you'll see a term, major grid lines. There can be minor grid lines also in some charts. We get used to these pretty quickly. We don't have to memorize them or anything like that. There's a legend in this chart off to the right. I slide over that, see Legend. Over on the left-hand side, there's a title down the left-hand side.
Says it's a vertical axis title. Also has the world value, sometimes referred to as the value axis title, so we see these terms anytime we work with charts we get used to them, we become familiar with them, it also becomes important at certain times when we are making editing changes to a chart, If you click a chart, selecting it, you will see two contextual tabs up above. Here's a format tab, and right now on the left side of the format tab, it says Chart Area. There's a drop arrow there, and we see other areas in there as well too.
I haven't pointed to one of the columns just yet, but as I do, we'll see one of the terms here, series referring to one of the columns, so in this chart, point to this column, we see the pop-up, series June point domestic value 180, so I get used to the term, a series, as well here, and that's a particular point in the June series. The pink chart here below the line chart is a 3D column chart. As I slide onto the background there, first we see plot area, and then moving downward here, this is called the back wall.
Off to the right, the side wall, and you probably guessed it already, but down below, what do we have? It's called a floor, so we see terms here that we wouldn't always necessarily guess, but at the same time, as we work with charts, would become more familiar with this terminology. The pie chart over here has an area out here, that's the plot area, but just beyond that is the chart area. Sometimes the plot area almost overlaps the chart area, but not quite. Outer area is chart area, inner area is plot area. This is part of a series here, so every item that we see here has a name, and from time to time, although it's not really necessary, on the format tab, far left side here, after clicking the drop arrow, you see different choices related to that particular chart.
I'll jump over to the line chart again momentarily, just click on it, and the number of choices we see there varies, different than what we saw earlier. So, these terms, not to be memorized, but you'll see them frequently. Chart area, plot area, legend, series, those are the terms you become familiar with as you work with charts in Excel.
- Selecting data for a chart
- Creating charts with keystrokes and ribbon icons
- Selecting the right chart type
- Adding titles, labels, and gridlines
- Choosing a chart layout
- Changing a chart's location
- Adding gridlines, data tables, and trendlines
- Formatting charts
- Creating column, bar, line, pie, and scatter charts
- Changing a chart's source data
- Creating Gantt and frequency charts
- Printing and sharing charts
- Converting a chart to a graphic