HP 95LX - Page 76

Graphing Data from 1-2-3
You can use the built-in graphing capability of Lotus 1-2-3 to make five different
kinds of graphs based upon data stored in the worksheet. The five types are:
* Bar Graph Compares related data at a given point in time.
¢ Line Graph Shows changes in a value over a period of time.
* Pie Chart Shows relative sizes of components of a whole.
e Stacked Bar Graph Compares related data at two or more points in time.
¢ XY Graphs Shows correlations between two types of numeric data
—very similar to the function plot in the Solver.
The following examples assume that you have data already stored in up to six data
ranges (though you may not need that many for most of your graphs). Each data
range is usually just one column.
To create a Bar graph:
1. From the open worksheet containing the data you plan to graph, press (MENU),
(Graph, Thpe, (Bla r.
2. Press (X), and type in the range that contains the labels for the x-axis data, and
press [ENTER]. These labels will show up below each bar.
3. Decide how many data ranges the graph will contain. One data range will
result in a simple bar graph—one bar for each label. Two data ranges will
result in two bars (each with different shading) for each label—allowing a
before/after kind of comparison.
4. Press(A), and type in the first data range, and press (ENTER). If you have a second
data range, press (B), type in the range, and press ENTER). Proceed like this to
include up to six (through data range F) columns of data.
5. Press to view the graph. If you want to see more detail, press (4), and then
use the arrow keys to scroll around. Press (=) to return to the smaller size. Press
to remove the graph from the display.
6. If you want to add enhancements to the graph—explanatory text, titles,
“colors,” grid lines, and so forth—see page 79.
7. To save the graph for later use or printing, see page 79.
8. When you finish, press (Quit at the Graph menu to return to the worksheet.
76 2. ANALYZING INFORMATION