Module 4 Excel Definitions Flashcards
100% stacked column chart
A column chart that places the data series values within combined columns showing what percentage is contributed by each series.
axis title
Descriptive text that appears next to an axis
bar chart
A column chart turned on its side so that the length of each bar is based on its value.
category values
The groups or categories to which series values belong.
chart
A visual representation of a set of data values; also called a graph.
chart area
The chart and all of the other chart elements.
chart design theory
Edward Tufte
chart element
An individual part of a chart, such as the title or the legend.
chart junk
a proliferation of chart elements—chosen because they look “nice”—confuse and distract the reader.
chart legend
A box that identifies the data markers associated with each data series.
chart subtype
A variation of a chart type
chart title
A descriptive label or name for the chart.
clustered column chart
A column chart that displays the data values in separate columns side by side.
column chart
A chart that displays data values as columns with the height of each column based on its value.
combination chart
A chart that combines two or more Excel chart types into a single graph.
data bar
A conditional format that adds a horizontal bar to the background of a cell proportional in length to the cell’s value.
data callout
A data label that appears as a callout bubble pointing to a data marker.
data label
Text associated with an individual data marker.
data marker
A graphical representation of a value in a chart, such as a column or pie slice.
data series
The range that contains the values plotted on a chart.
data source
The range that contains the data to display in a chart.
data-ink ratio
the amount of “ink” used to display quantitative information compared to the total ink required by the chart. A high data-ink ratio with a minimum of extraneous elements and graphics is preferred.
embedded chart
A chart object placed in a worksheet.
Format pane
An area that provides a collection of commands to format the selected chart element.
gap width
width between one category value and the next.
graph
A visual representation of a set of data values; also called a chart.
gridline
In a chart, a line that extends the value of a major or minor tick mark across the plot area.
hierarchy chart
A chart that show the relative contribution of groups to a whole.
honesty in charting
- Improper Scaling; 2. Scaling data values differently; 3. Truncating the vertical axis; 4. 3-D distortions.
horizontal axis
The axis that displays the category values from each data series.
leader line
A line that connects a data label to its corresponding data marker.
line chart
A chart that displays data values using a connected line rather than columns or bars.
major tick marks
Lines that identify the main units on a chart axis.
minor tick marks
Lines that identify the smaller intervals between major tick marks on a chart axis.
pie chart
A chart in the shape of a circle divided into slices like a pie; shows data values as a percentage of the whole.
plot area
The part of a chart that contains the graphical representation of the data series.
PMT function
The financial function that calculates the payment schedule required to repay a loan.
primary axis
The axis against which data series in a chart is plotted; usually appears along the left side of a chart.
scale
In a chart, the range of values displayed on a chart axis.
secondary axis
An alternate axis in a chart against which other data series with a different scale is plotted; usually appears on the right side of a chart.
selection box
A box surrounding an object such as a chart that is used to move or resize the object.
Series Overlap
overlap between two charts
sizing handle
A square or dot on the edge of a selection box that is used to change the object’s width and height.
sparkline
A chart that is displayed within a worksheet cell.
stacked column chart
A column chart that places the data series values within combined columns showing how much is contributed by each series.
tick marks
A line that divides the scale into regular intervals on a chart axis.
vertical axis (value axis)
The axis that displays the values from the data series.