Week 6 Vocabulary
Organization chart:
a type of graphic that is useful to depict reporting relationships within an organization
Text pane:
a window that displays to the left of a SmartArt graphic, is populated with placeholder text, and is used to build a graphic by entering and editing text.
Chart sheet:
a workbook sheet that contains only a chart
Chart elements:
objects that make up a chart
Horizontal category axis (x-axis):
The area along the bottom of a chart that identifies the categories of data; also referred to as the x-axis
Process:
a category of Smart Art graphics that is used to show steps in a process or timeline.
Cycle:
a category of SmartArt graphics that illustrates a continual process
Picture:
a category of SmartArt graphics that is used to display pictures in a diagram
Relationship:
a category of SmartArt graphics that is used to illustrate connections
Pyramid:
a category of SmartArt graphics that uses a series of pictures to show relationships
Hierarchy:
a category of SmartArt graphics used to create an organization chart or show a decision tree
Matrix:
a category of SmartArt graphics used to show how parts relate to a whole
List:
a category of SmartArt graphics used to show non-sequential information
Legend:
a chart element that identifies the patterns or colors that are assigned to the categories in the chart
Column chart:
a chart in which the data is arranged in vertical columns and that is useful for showing data changes over a period of time or for illustrating comparisons among items
Embedded chart:
a chart that is inserted into the same worksheet that contains the data used to create the chart
Line chart:
a chart type that is useful to display trends over time; time displays along the bottom axis and the data point values are connected with a line
Data marker:
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
Protection:
a feature that prevents anyone from altering the formulas or changing other template components
Orientation:
a feature with which you can rotate text diagonally or vertically in a cell and is useful when you need to label a narrow column
Trendline:
a graphic representation of trends in a data series, such as a line sloping upward to represent increased sales over a period of months
Axis:
a line that serves as a frame of reference for measurement and that borders the chart plot area
Major unit value:
a number that determines the spacing between tick marks and between the gridlines in the plot area
Vertical value axis (y-axis):
a numerical scale on t he left side of a chart that shows the range of numbers for the data points; also referred to as the y-axis
Template:
a special workbook that may include formatting, formulas, and other elements and is used as a pattern for creating other workbooks
Data point:
a value that originates in a worksheet cell and that is represented in a chart by a data marker
SmartArt graphic:
a visual representation of information and ideas.
Standardization:
all forms created within the organization will have a uniform appearance; the data will always be organized in the same manner
Recommended charts:
an Excel feature that helps you choose a chart type by previewing suggested charts based on patterns in your data
Password:
an optional element of a template added to prevent someone from disabling a worksheet's protection
Unlocked [cells]:
cells in a protected worksheet that may be filled in
Labels:
column and row headings that describe the values and help the reader understand the chart
Tick mark labels:
identifying information for a tick mark generated from the cells on the worksheet used to create the chart
Locked [cells]:
in a protected worksheet, data cannot be inserted, modified, deleted, or formatted in these cells
Data labels:
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
Gridlines:
lines in the plot area that aid the eye in determining the plotted values
Data series:
related data points represented by data markers; each data series has a unique color or pattern represented in the chart legend
Plot area:
the area bounded by the axes of a chart, including all the data series.
Walls and floor:
the areas surrounding a 3-D chart that give dimension and boundaries to the chart
Chart area:
the entire chart and all of its elements
Category labels:
the labels that display along the bottom of a chart to identify the categories of data
Scale:
the range of numbers in the data series that controls the minimum, maximum, and incremental values on the value axis
Tick marks:
the short lines that display on an axis at regular intervals
Sparklines:
tiny charts that fit within a cell and give a visual trend summary alongside data