If you follow the stock market, you may have a need to chart the high, low, and closing price of a stock. In ClarisWorks 2.X and 3.X, there is a Chart Option called Hi-Low that will allow charting of data in this style. However, the data must be set up in pairs in order for the Hi-Low to display correctly. This can be a problem when the closing price of the stock is a single value. Fortunately, you can still use the Hi-Low chart option with a little creative spreadsheet management.
Assuming that you want to plot the high, low, and closing prices of companies A, B, C, D and E, you would create a spreadsheet similar to the following (see also Figure 1).
ColumnA ColumnB ColumnC ColumnD ColumnE
Row1 hi/low close
Row2 StockA 53 16 33 33
Row3 StockB 72 13 63 63
Row4 StockC 52 8 24 24
Row5 StockD 85 22 76 76
Row6 StockE 54 39 46 46
Assuming that you want to plot the high, low, and closing prices of companies A, B, C, D and E, you would create a spreadsheet similar to the following (see also Figure 1).
ColumnA ColumnB ColumnC ColumnD ColumnE
Row1 hi/low close
Row2 StockA 53 16 33 33
Row3 StockB 72 13 63 63
Row4 StockC 52 8 24 24
Row5 StockD 85 22 76 76
Row6 StockE 54 39 46 46
The trick here is to repeat the closing price a second time to simulate a high-low pair.
Then, select the cell range A1..E6 and choose Make Chart from the Options menu. Since the closing prices are pairs of the same number, what you will end up having on your chart is a high-low vertical line for the high and low stock prices, and a single tick line or hash mark somewhere along this vertical line for the closing price (see Figure 2).
Figure 1: Sample Spreadsheet
Figure 2: Sample Hi-Low Chart