Loading input.gsc-input { border-color: #BCCDF0; } input.gsc-search-button { border-color: #666666; background-color: #CECECE; }
 Everything HP200LX: Knowledge, Products, Service
 Archives 9 years, 100's of pages of HP Palmtop Paper, jammed with tips, reviews and how-to's Links Most useful, up-to-date Web sites devoted to the HP 200LX Downloads 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)
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.