Manual

.
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
itemsper 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