Upgrade to remove ads
Excel Chapter 3 Vocabulary
Terms in this set (41)
100% stacked column chart
A chart type that places (stacks) data in one column per category, with each column the same height of 100%.
A chart type that emphasizes magnitude of changes over time by filling in the space between the lines with a color.
Category or incremental value labels to identify the measurements along the horizontal and vertical axes of a chart.
A label that describes either the category axis or the value axis. Provides clarity, particularly in describing the value axis.
A chart type that compares values across categories using horizontal bars. In this chart, the horizontal axis displays values and the vertical axis displays categories.
A chart type that shows relationships among three values by using bubbles to show a third dimension. The third bubble is indicated by the size of the bubble; the larger the bubble, the larger the value.
The chart element that displays descriptive group names or labels, such as city names or departments, to identify data.
Text that describes a collection of data points in a chart.
A visual representation of numerical data and helps reveal trends or patterns to help people make informed decisions.
A boundary that contains the entire chart and all of its elements, including the plot area, titles, legends, and labels.
A component of a chart that helps complete or clarify the chart.
A setting that controls what data series are displayed or hidden in a chart.
A sheet within a workbook that contains a single chart and no spreadsheet data.
A collection of formatting that controls the color of the chart area, plot area, and data series.
The label that describes the entire chart. It is usually placed at the top of the chart area.
Clustered column chart
A type of chart that groups, or clusters, similar data into columns to compare values across columns.
A type of chart that displays data vertically in columns to compare values across different categories.
A chart that combines two chart types, such as a column and line, to plot different types of data, such as quantities and percentages.
An identifier that shows the exact value of a data point on the value axis in a chart. Appears above or on a data point in a chart. May indicate percentage of a value to the whole on a pie chart.
A numeric value that describes a single value in a chart or worksheet.
A group of related data points that display in row(s) or column(s) in a worksheet.
A grid that contains the data source values and labels to plot data in a chart. It may be placed below a chart or hidden from view.
A chart type that displays values as percentages of the whole but may contain more than one data series.
Visual that indicates the standard error amount, a percentage, or a standard deviation for a data point or marker.
Exploded pie chart
A chart type in which one or more pie slices are separated from the rest of the pie chart for emphasis.
A horizontal or vertical line that extends from the horizontal or vertical axis through the plot area to guide the reader's eyes across the chart to identify values.
A key that identifies the color, gradient, picture, texture, or pattern assigned to each data series in a chart.
A chart type that displays lines connecting data points to show trends over equal time periods, such as months, quarters, years, or decades.
A chart type that shows each data point in proportion to the whole data series as a slice in a circle. This chart depicts only one data series.
The region of a chart containing the graphical representation of the values in a data series.
A chart type that compares aggregate values of three or more variables represented on axes starting from the same point.
A series of faint dots on the outside border of a selected chart or object; enables the user to adjust the height and width of the chart or object.
A small line, column, or win/loss chart contained in a single cell to provide a simple visual illustrating one data series.
Stacked column chart
A chart type that places stacks of data in segments on top of each other in one column, with each category in the data series represented by a different color.
A chart type that shows fluctuations in stock changes, such as the high, low and closing stock prices for a given company on a given day.
A chart type that displays trends using two dimensions on a continuous curve.
A line that depicts trends or helps forecast future data in a chart.
The chart element that displays incremental numbers to identify approximate values, such as dollars or units, of data points in a chart.
XY (scatter) chart
A chart type that shows the relationship between two variables using their X and Y coordinates. These charts are often used to represent data in educational, scientific, and medical experiments.
A horizontal border that provides a frame of reference for measuring data horizontally on a chart.
A vertical border that provides a frame of reference for measuring data vertically on a chart.
THIS SET IS OFTEN IN FOLDERS WITH...
Excel Chapter 1 Vocabulary
Excel Chapter 2 Vocabulary
Excel Chapter 4 Vocabulary
Excel Chapter 5 Vocabulary
YOU MIGHT ALSO LIKE...
BITM Excel 3
Chapter 4 (Charts)
Chapter 3: Charts (EXCEL)
OTHER SETS BY THIS CREATOR
Chapter 10 Key Terms
Chapter 9 Key Terms
Chapter 8 Key Terms
Chapter 7 Key Terms