| A | B |
|---|
| 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 proportional to its value. |
| category values | The groups or categories that a series values belong to. |
| 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 element | An individual part of a chart, such as the title or the legend. |
| chart subtype | A variation of a chart type. |
| chart title | A descriptive label or name for the chart area. |
| 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 proportional to 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. (EX 219) |
| 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 displayed in a chart. |
| embedded chart | A chart object placed in a worksheet. |
| exploded pie chart | A pie chart that moves one slice away from the others as if someone were taking the piece away from the pie. |
| filter | The process of limiting data to a subset of the original values. |
| Format pane | An area that provides a collection of commands to format the selected chart element. |
| graph | A visual representation of a set of data values; also called a chart. |
| gridline | A line that extends the value of a major or minor tick mark across the plot area of a chart. |
| horizontal axis (category axis) | The axis that displays the category values from each data series. |
| interest | The amount added to the principal by the lender. |
| 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. |
| pie chart | A chart in the shape of a circle divided into slices like a pie that show 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. |
| principal | The amount of money being loaned. |
| scale | The range of values displayed on a chart axis. |
| selection box | A box surrounding an object such as a chart that is used to move or resize the object. |
| 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 entirely 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 mark | A line that identifies the units at regular intervals on a chart axis. |
| vertical axis (value, axis) | The axis that displays the series values from the data series. |
| watermark | Text or an image that appears in the background of each page behind other content. |
| XY scatter chart | A chart that shows the pattern or relationship between two or more sets of values. |
