Business Analytics Chapter 3 Vocabulary
Terms in this set (44)
100% stacked column chart
A chat type that places (stacks) data in one column per category, with each column the same height of 100%
A chart that combines the features of a pie chart with those of line charts
Category or incremental value labels to identify the measurements along the horizontal and vertical axes of a chart
A label that describes with the category axis or the value axis. Provides clarity, particularly in describing the value axis.
A horizontal bar chart
A type of scatter chart in which the size of the data marker corresponds to the value of a third variable - a way to plot thre variables in two dimensions
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. The title 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 vertical bar chart
A chart that combines two chart types, such as 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
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. A data table may be placed below a chart or hidden from view.
A chart that is similar to a pie chart but can 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 that provides a useful means for displaying data over time
A chart that partitions a circle into pie-shaped areas showing the relative proportion of each data source to the total
A data analysis tool provided by Microsoft Excel, which enables visualizing data in PivotTables
A powerful tool, provided by Excel, for distilling a complex data set into meaningful information
The region of a chart containing the graphical representation of the values in the data series
A chart that allows plotting of multiple dimensions of several data sets
A chart that shows the relationship between two variables
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.
Graphics that summarize a row or column of data in a single cell
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 that allows plotting of stock prices, such as the daily high, low and close
A chart that shows 3-D data
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 a relationship between two variables using their X and Y coordinates. Excel plots one coordinate on the horizontal X-axis and the other variable on the vertical Y-axis. They 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.