Table of Contents
Advertisement
.
4.
5.
Click on OK.
Click on Close.
Create
the formula
with a circular
reference.
Spreadsbeet
recalculates
the
formula
the specified
number
of times or stops when
the stated
value for
maximum
change
is calculated.
Charting in Spreadsheet
Spreadsheet
lets you create
a variety
of charts
that represent
numeric
trends
or results.
You can include
a chart
as a part of your spreadsheet.
Or, after
creating
a chart,
you can copy
it to the clipboard
and
use it in other
programs
like Drawing
or Word Processing.
This section begins by describing
the types of charts you can create.
Information on creating and modifying
charts begins on page 108. Information
on printing charts begins on page 121.
What Is a Chart?
D_ not pIot rnorethan 12
items per chart.
A chart
is a graphic
representation
of numeric
data.
For example,
you can
create
a chart to show
the value
of the consumer
price index
over a period
of
years,
the total revenue
for a company
broken
down
by region,
or the
average
student
test grade
through
the school
year.
Charts
show
the relationships-between
a sem'es of va/u_s
broken
down
into
categories.
For example,
in a chart
of monthly
expenses,
the series
would
include
January,
February,
March,
and so forth; the categories
would
include
items like Rent, Food,
and Utilities;
and the values
would
be the actual
expenditure
incurred.
To create
a chart,
f'n'st select the data you want
to create
a chart from.
You can
select
a portion
of an existing
spreadsheet,
or cream
a new spreadsheet
and
enter the data to chart.
The following illustration shows the genet:al format for data on which you
base a chart:
R
t
Chart Tide
2
C_egory Nm_iya_,
3
CategoryNeme vahe
C_eoo._ N _ivn_.. ,,,
6
i
7
!
I
e
t:
I
o
'_
I
iSeries Name Series Name !Series Name
series Name i
tvabe
vabe
Iva/ue
i
i,,_,
" i,,a,a
i_
i
.... i,_,
ivan.
],_t_
i
Iv_
ivatua
ivnt_
i
I
I
i
!
i
i
i
i-
Spreadsheet
102
Advertisement
Table of Contents
