Search
Browse
Create
Log in
Sign up
Log in
Sign up
Excel Chapter 3 Vocabulary
STUDY
Flashcards
Learn
Write
Spell
Test
PLAY
Match
Gravity
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%.
Area chart
A chart type that emphasizes magnitude of changes over time by filling in the space between the lines with a color.
Axis
Category or incremental value labels to identify the measurements along the horizontal and vertical axes of a chart.
Axis title
A label that describes either the category axis or the value axis. Provides clarity, particularly in describing the value axis.
Bar chart
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.
Bubble chart
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.
Category axis
The chart element that displays descriptive group names or labels, such as city names or departments, to identify data.
Category label
Text that describes a collection of data points in a chart.
Chart
A visual representation of numerical data and helps reveal trends or patterns to help people make informed decisions.
Chart area
A boundary that contains the entire chart and all of its elements, including the plot area, titles, legends, and labels.
Chart element
A component of a chart that helps complete or clarify the chart.
Chart filter
A setting that controls what data series are displayed or hidden in a chart.
Chart sheet
A sheet within a workbook that contains a single chart and no spreadsheet data.
Chart style
A collection of formatting that controls the color of the chart area, plot area, and data series.
Chart title
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.
Column chart
A type of chart that displays data vertically in columns to compare values across different categories.
Combo chart
A chart that combines two chart types, such as a column and line, to plot different types of data, such as quantities and percentages.
Data label
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.
Data point
A numeric value that describes a single value in a chart or worksheet.
Data series
A group of related data points that display in row(s) or column(s) in a worksheet.
Data table
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.
Doughnut chart
A chart type that displays values as percentages of the whole but may contain more than one data series.
Error bar
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.
Gridline
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.
Legend
A key that identifies the color, gradient, picture, texture, or pattern assigned to each data series in a chart.
Line chart
A chart type that displays lines connecting data points to show trends over equal time periods, such as months, quarters, years, or decades.
Pie chart
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.
Plot area
The region of a chart containing the graphical representation of the values in a data series.
Radar chart
A chart type that compares aggregate values of three or more variables represented on axes starting from the same point.
Sizing handles
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.
Sparkline
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.
Stock chart
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.
Surface chart
A chart type that displays trends using two dimensions on a continuous curve.
Trendline
A line that depicts trends or helps forecast future data in a chart.
Value axis
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.
X-axis
A horizontal border that provides a frame of reference for measuring data horizontally on a chart.
Y-axis
A vertical border that provides a frame of reference for measuring data vertically on a chart.
YOU MIGHT ALSO LIKE...
Marketing Research
TextbookMediaPremium
$9.99
STUDY GUIDE
BITM Excel 3
41 Terms
sraemsanchez
Chapter 4 (Charts)
41 Terms
hbrousseau
Chapter 3: Charts (EXCEL)
41 Terms
hope87
OTHER SETS BY THIS CREATOR
Chapter 10 Key Terms
27 Terms
Sidney_Whitted
Chapter 9 Key Terms
8 Terms
Sidney_Whitted
Chapter 8 Key Terms
9 Terms
Sidney_Whitted
Chapter 7 Key Terms
6 Terms
Sidney_Whitted
THIS SET IS OFTEN IN FOLDERS WITH...
Excel Chapter 1 Vocabulary
43 Terms
Sidney_Whitted
Excel Chapter 2 Vocabulary
35 Terms
Sidney_Whitted
Excel Chapter 4 Vocabulary
17 Terms
Sidney_Whitted
Excel Chapter 5 Vocabulary
16 Terms
Sidney_Whitted
;