Identifies which data series each colour in the chart represents.

Table of Contents Show

What identifies which data series each color represents in a chart?
What represents data series in a chart?
Which of the following items identifies what each data series in a chart represents?
What is the key that identifies the color or pattern fill assigned to each data series in a chart?

A	B
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.