Chapter 9: Pie Charts, Line Charts and What-If Analyses

legend

a chart element that identifies the patterns or colors that are assigned to the categories in the chart

pie chart

a chart that shows the relationship of each part of a whole

line chart

a chart type that displays trends over time

data marker

a column, bar, area, dot, pie slice or other symbol in a chart that represents a single data point

WordArt

a gallery of text styles with which you can create decorative effects, such as mirrored or shadowed text

value axis

a numerical scale on the left side of a chart that shows the range of numbers for the data points

bevel

a shape effect that uses shading and shadows to make the edges of a shape appear to be curved or angled

fund

a sum of money set aside for a particular purpose

goal seek

a what-if analysis tool that finds the input needed in one cell to arrive at the desired result in another cell

formula auto complete

after typing an = sign and the beginning letter or letters of a function name, this Excel feature displays a list of function names that match typed letters from which you can insert the function

3-D

an image that appears to have all three dimensions-length, width and depth.

general fund

money set aside for the normal operating activities of a government entity such as a city

data series

related data points represented by data markers

format as you type

the Excel feature by which a cell takes on the formatting of the number typed into the cell

explode

the action of pulling out one or more pie slices from a pie chart for emphasis

relative cell reference

the address of a cell based on the relative position of the cell that contains the formula and the cell referred to

plot area

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

Order of operations

the mathematical rules for performing multiple calculations within a formula

percentage rate of increase

the percent by which one number increases over another number

chart elements box

the place in Chart Tools tab from which you can select an element so that you can format it

what-if analysis

the process of changing values in cells to see how those changes affect the outcome of formulas in a worksheet

tick marks

the short lines that display on an axis at regular intervals

base

the starting point when you divide the amount of increase by an ad network

major unit

the value in a chart's value axis that determines the spacing between tick marks and between gridlines in the plot area