Chapter 6

Cycle

a category of SmartArt graphics that illustrates a continual process.

Recommended charts

an excel feature that helps you choose a chart type by previewing suggested charts based upon 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.

Tick marks

the short lines that display on an axis at regular intervals.

Organization Chart

a type of graphic that is useful to depict reporting relationships within an organization.

Labels

column and row headings that describe the values and help the reader understand the chart.

Locked cells

in a protected worksheet, data cannot be inserted, modified, deleted or formatted in these cells.

Picture

a category of SmartArt graphics that is used to display pictures in the diagram.

Relationship

a category of SmartArt graphics that is used to illustrate connections.

Process

a category of SmartArt graphics that is used to show steps in a process or timeline.

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 part relate to the whole.

List

a category of SmartArt graphics used to show non-sequential info.

Pyramid

a category of smartart graphics that uses a series of pictures to show relationships.

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 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 charts

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.

Rotation handle

a circle that displays on the top side of a selected object used to rotate the object up to 360 degrees.

Data marker

a column, bar, area, dot, pie slice, or other symbol in chart that represents a single data point; related data points form a data series.

WordArt

a feature with which you can insert decorative text in your document.

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 in between the gridlines in the plot area.

Vertical axis (y-axis)

a numerical scale on the left side of a chart that shows the range of numbers for the data points; also referred to as the y-axis.

Scale

a range of numbers in the data series that controls the minimum , maximum, and incremental values on the value axis.

Template

a special workbook which may include formatting, formula, and other elements, that 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 graphics

a visual representation of information and ideas.

Chart sheet

a workbook sheet that contains only a chart.

Standardization

all forms created within the organization will have a uniform appearance; the data will always be organized in the same manner.

Tick mark labels

identifying info for a tick mark generated from the cells on the worksheet used to create the chart.

Data labels

lables 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.

Chart elements

objects that make up a chart.

Data series

related data points represented by data markers; each data series has a unique color or pattern represented in the chart legend.

Protection

that prevents someone from altering the formulas or changing other template components.

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.

Plot area

the area bounded by the axes of a chart, including all the data series.

WAlls and floor

the area 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 the data.

Text pane

the pane that displays to the left of the graphic, is populated with placeholder text , and is used to build a graphic by entering and editing text.

Sparklines

tiny charts that fit within a cell and give a visual trend summary alongside data.