Everything HP200LX: Knowledge, Products, Service

9 years, 100's of pages of HP Palmtop Paper, jammed with tips, reviews and how-to's

Most useful, up-to-date Web sites devoted to the HP 200LX

Direct link into 1000's of pieces of Palmtop software

Tips from Our Techs

2008 Catalog
(PDF, 2.6 MB)

Contact Us/About Us

Weekly Palmtop Paper Newsletter
(Palmtop tips, latest happenings, and HP Palmtop Paper Store information)



Privacy Policy

Break the Six Range Limit in 1-2-3 Graphs
Break the Six Range Limit in 1-2-3 Graphs

With the Lotus 1-2-3 Graph command you can specify which set of values to use for the X-axis and up to six different sets of values for the Y-axis.

There may be an occasion when you would like to have more than six values displayed on the graph at the same time. Here's how to do this for graphs of the x-y type.

1) Set up a spreadsheet as usual for the X-axis and for up to the six data ranges (A - F) for the Y-axis. In Screen 1 the columns A-F will become the Y-axis values and the G column will become the X-axis values.

Screen 1: A Spreadsheet with 12 different graph ranges

2) Copy the X-axis values into the same column below the first set of X-axis values. Leave one blank row between the two sets.

3) Construct up to six additional ranges, using the same columns as previously defined for ranges A - F but, again, leave a blank cell between the sets of values.

4) Repeat steps 2 and 3 if you want 18 ranges instead of 12.

5) Tell the Graph program that you want to plot an X-Y graph and identify your ranges as extending from the first row of the first set to the last row of the last set.

For example, in the spreadsheet above, the X-axis values are in cells G1..G11. The A-F values are in cells A1..A11 through F1..F11.

Be sure to leave the blank cells between the different data sets or else you'll get stray lines connecting the first and seventh series, the second and eighth and so on.

When you're ready, view the graph by pressing the F10 key or by choosing the View command in the 1-2-3 Graph menu.

You should see a graph like the one in Screen 2 in which there are twelve different lines on the chart.

Screen 2: An X-Y type graph with 12 different values for the Y axis.

The technique can be extended to handle as many "pseudo ranges" as you like. However, on the Palmtop, the screen resolution is such that too many lines produce a blur.

iPhone Life magazine

Notice about Palmtop.net
The Palmtop Network with its S.U.P.E.R. (Simply Unbeatable Palmtop Essentials Repository) software is now available under the domain name of hp200lx.net.  

We Buy
We buy used palmtops, working or broken: HP 200LX, HP 100LX and 1000CX.

Copyright 2010 Thaddeus Computing Inc