Chapter 6

Cycle

a category of SmartArt graphics that illustrates a continual process.

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.

Organization Chart

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

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.

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.

Labels

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

Tick mark labels

identifying info 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

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.

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.