Excel Lesson 8

Front 1

Chart

Back 1

is a graphical representation of data

Front 2

Chart area

Back 2

a type of presentation graphic that emphizises a change in values by filling by filling in the portion of the graph beneath the line connecting various data points

Front 3

chart layout

Back 3

specifies which element are included in a chart and where they are placed.

Front 4

chart sheet

Back 4

seperate sheet in a workbook that stores a chart.

Front 5

chart style

Back 5

formats the charts based on the colors, fonts, and effects associated with the workbooks theme.

Front 6

column chart

Back 6

uses bars of varying heights to illustrate data in a worksheet

Front 7

data label

Back 7

is a statistic part of a chart, report or other dynamic layout.

Front 8

data marker

Back 8

A bar, area, dot, slice, or other symbol in a chart that represents a single data point or value that originates from a datasheet cell. Related data markers in a chart constitute a data series.

Front 9

Data series

Back 9

Related data points that are plotted in a chart and originate from datasheet rows or columns. Each data series in a chart has a unique color or pattern. You can plot one or more data series in a chart. Pie charts have only one data series.

Front 10

Data source

Back 10

A stored set of "source" information used to connect to a database. A data source can include the name and location of the database server, the name of the database driver, and information that the database needs when you log on.

Front 11

Data table

Back 11

A range of cells that shows the results of substituting different values in one or more formulas. There are two types of data tables: one-input tables and two-input tables.

Front 12

Embedded Chart

Back 12

A chart that is placed on a worksheet rather than on a separate chart sheet. Embedded charts are beneficial when you want to view or print a chart or a PivotChart report with its source data or other information in a worksheet

Front 13

Exploded pie chart

Back 13

one slice or multiple slices away from the pie to distinguish them

Front 14

Legend

Back 14

A box that identifies the patterns or colors that are assigned to the data series or categories in a chart.

Front 15

line chart

Back 15

are used to show trends over time. Each line in the graph shows the changes in the value of one item of data.

Front 16

pie chart

Back 16

is a circular chart in which the circle is divided into sectors.

Front 17

plot chart

Back 17

it is the part of a chart that shows the actual data, such as where bars are in a bar chart or lines in a line chart, this does not include tables and legends.

Front 18

Scatter chart

Back 18

The scatter chart allows you to create a chart showing one piece of information, such as market capitalisation, along the x-axis and another piece of information,

Front 19

sparkline

Back 19

is a small embedded line graph that illustrates a single trend.they are often used in reports,presentations,they do not include axes or lables, context comes from the related content.

Front 20

axis

Back 20

An imaginary straight line passing through the center of a symmetrical solid,