Excel - Chapter 3
Terms in this set (20)
A label that describes either the category axis or the value axis. Provides clarity, particularly in describing the value axis.
A chart type that compared values across categories using horizontal bars. In a bar chart, the horizontal axis displays values and the vertical axis displays categories.
The chart element that displays descriptive group names or labels, such as city names or departments, to identify data.
A boundary that contains the entire chart ad all of its elements, including the plot area, titles, legends, and labels.
The labels that describe 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 the columns.
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 horizontal or vertical line that extends from the horizontal or vertical axis through the plot area to guide the readers 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 ends 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 I a circle. A pie chart depicts only one data series.
The region of a chart containing the graphical representation of the values in the data series.
A series of faint dots on the outside border of a selected chart or objects; 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.
A chart type that shows fluctuations in stock changes, such as the high, low, ad closing stock prices for a give company on a given day.
Window of options to format and customize chart elements.
The chart element that displays incremental numbers to identify approximate values, such as dollars or units, of data in a PivotTable.
X Y (scatter) chart
A chart type that shows a relationship between two variables using their X and Y coordinates. Excel plots ne coordinate on the horizontal X-axis and the other variable on the vertical Y-axis. Scatter charts are often used to represent data in educational, scientific, and medical experiments.