Axis | A line that serves as a frame of reference for measurement and which borders the chart plot area. |
Category Labels | The labels that display along the bottom of a chart to identify the categories of data; Excel uses the row titles as the category names. |
Chart Area | The entire chart and all of its elements. |
Chart Sheet | A workbook sheet that contains only a chart. |
Column Chart | The letter that displays at the top of a vertical group of cells is useful for showing data changes over a period of time or for illustrating comparisons among items. |
Cycle | A continual process diagram. |
Data Label | Labels that display the value, percentage, and/or category of each particular data point and can contain one or more of the choices listed- Series name, Category name, Value, or Percentage. |
Data Markers | A column, bar, area, dot, pie slice, or other symbol in a chart that represents a single data point; related data points form a data series. |
Data Points | A value that originates in a worksheet cell and that is represented in a chart by a data marker. |
Data Series | Related data points represented by data markers; each data series has a unique color or pattern represented in the chart legend. |
Embedded Chart | A chart that is inserted into the same worksheet that contains the data used to create the chart. |
Gridlines | Lines in the plot area that aid the eye in determining the plotted values. |
Hierarchy | A category of SmartArt graphics used to create an organization chart or show a decision tree. |
Horizontal Category Axis (X-Axis) | This displays along the bottom of the chart to identify the category of data. |
Labels | Column and row headings that describe the values and help the reader understand the chart. |
Legend | A chart element that identifies the patterns or colors that are assigned to the categories in the chart. |
Line Charts | A chart type that is useful to display trends over time; time displays along the bottom axis and the data points values are connected with a line. |
List | 1. A series of rows that contains related data that you can group by adding subtotals. 2. A category of SmartArt graphics used to show nonsequential information. |
Locked [Cells] | Formula cells that prevent others from changing the formulas in the template. |
Major Unit Value | A number that determines the spacing between tick marks and between the gridlines in the plot area. |
Matrix | A category of SmartArt graphics used to show how parts relate to a whole. |
Organization Chart | A type of graphic that is useful to depict reporting relationships within an organization. |
Password | An optional element of a template added to prevent someone from disabling a worksheet's protection. |
Picture | A type of graphic that is useful to display pictures in a diagram. |
Plot Area | The area bounded by the axes of a chart, including all the data series. |
Process | A category of SmartArt graphics that is used to show steps in a process or timeline. |
Protection | This prvents anyone from altering the formulas or changing other template components. |
Pyramid | A category of SmartArt graphics that uses a series of pictures to show relationships. |
Relationship | A category of SmartArt graphics that is used to illustrate connections. |
Rotation Handle | A green circle that displays on the top side of a selected object. |
Scale | The range of numbers in the data series that controls the minimum, maximum, and incremental values on the value axis. |
SmartArt Graphic | A visual representation of your information and ideas. |
Sparklines | Tiny charts that fit within a cell and give a visual trend summary alongside your data. |
Standardization | All forms created within the organization will have a uniform appearance; the data will always be organized in the same manner. |
Template | A wordbook used as a pattern for creating other workbooks. |
Text Pane | A movable resizable container for text or graphics. |
Tick Mark Labels | Identifying information for a tick mark generated from the cells on the worksheet used to create the chart. |
Tick Marks | The short lines that display on an axis at regular intervals. |
Tredline | A graphic representation of trends in a data series, such as a line sloping upward to represent increased sales over a period of months. |
Unlocked [Cells] | Cells in a template that may be filled in. |
Vertical Value Axis (Y-Axis) | This displays along the left side of the chart to identify the numbers for the data points; also referred to as the y-axis. |
Walls and Floor | The areas surrounding a 3-D chart that give dimension and boundaries to the chart. |
WordArt | A feature that transforms text into a stylized image that you can use to create a distinctive logo or heading. |
Chart elements | Objects that make up a chart. |
Recommended Charts | An Excel feature that helps you choose a chart type by previewing suggested charts based upon patterns in your data. |
What identifies which data series each color represents in a chart?
Formatting the chart legend
The chart legend displays useful information about the chart. Like a roadmap, the legend identifies what different colors or objects represent in the chart.
What represents data series in a chart?
A data series is a row or column of numbers that are entered in a worksheet and plotted in your chart, such as a list of quarterly business profits. Charts in Office are always associated with an Excel-based worksheet, even if you created your chart in another program, such as Word.
Which of the following items identifies what each data series in a chart represents?
The chart represents each data series as its own shape and color. Chart created within the worksheet. Horizontal Scale of a chart which categories are plotted, called the X-Axis. A key that identifies each of the data series in a chart.
What is the key that identifies the color or pattern fill assigned to each data series in a chart?
CH 3: Charts.