Excel Lesson 8

Front 1

axis

Back 1

represents the federal budget debt in billions of dollars, and the horizontal axis shows the years

Front 2

chart

Back 2

is a graphical representation of data

Front 3

chart area

Back 3

use the commands on the appropriate button to display that element in a particular location in the chart area or hide it

Front 4

chart layout

Back 4

specifies which elements are included in a chart and where they are placed

Front 5

chart sheet

Back 5

is a seperated sheet in a workbook that stores a chart

Front 6

chart style

Back 6

formats the chart based in the colors, fonts, and effects associated with workbook's theme

Front 7

column chart

Back 7

uses bars of varying heights to illustrate data in a worksheet

Front 8

data label

Back 8

text or numbers that provide additional information about a data marker

Front 9

data marker

Back 9

A pie chart shows the relationshop of a part to a whole. Each part is shown as a "slice" of the pie. The slices are different colors to distinguish each data marker

Front 10

data series

Back 10

is a group of related information in a column or row of a worksheet that is plotted on the chart

Front 11

data source

Back 11

In Excel, the chart data, called the data source, is stored in a ranfe of cells in the worksheet.

Front 12

data table

Back 12

you can choose when and where to display the chart title, axis title, legend, data labels, data table, axes, gridlines, and the plot area

Front 13

embedded chart

Back 13

After you select a chart type and subtype, the chart is inserted in the center of the worksheet

Front 14

exploded pie chart

Back 14

is when you pull one slice or multiple slices away from the pie to distinguish them

Front 15

legend

Back 15

list that identifies patterns, symbols, or colors used in a chart

Front 16

line chart

Back 16

is similar to column chart, but it uses points connected by a line instead of bars

Front 17

pie chart

Back 17

shows the relationship of parts to a whole

Front 18

plot area

Back 18

you can choose when and where to display the chart title, axis title, legend, data labels, data table, axes, gridlines, and the plot area

Front 19

scatter chart

Back 19

sometimes called an XY chart, shows the relationship between two categories of data, such as person's height and weight

Front 20

sparkline

Back 20

are mini charts that you can insert into a cell