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