Example of a Schoeller plot in Grapher.

With the release of Grapher 14 you can now plot data in both rows and columns.  Examples of Schoeller plot data in both layouts are shown below.

Example Schoeller data in rows

Example Schoeller data in columns

To create a schoeller plot in Grapher 14 or newer, complete the steps below:

1. Click Home | New Graph | Basic | Line Plot select the data file and click Open. 
2. Select the plot in the Object Manager.
3. Click the Plot tab in the Property Manager. 
4. If your data is in rows, check the box in the Data in rows field. 
5. Change the X variable to either Column number, Row number, or Sequence Number. 
6. Click the Create button to add the next row/column of data as a line plot. Continue until all plots are added. 
7. Click X Axis 1 in the Object Manager.
8. Click the Labels tab in the Property Manager.
9. Check the Show major tick labels box.
10. Set the Label Source to From worksheet.
11. Click in the Worksheet field and select your worksheet from the list.
    
12. If your data is in rows, check the box next to Data in rows. 
13. In the Data variable field, select the same option chosen in step 5 above. 
14. Set the Label Variable to the appropriate row or column in your data. 

Grapher 13 and earlier versions:

Because of the way data is read in earlier versions of Grapher, the raw data must be transposed and ordered in Excel before plotting. The data must be arranged so that each row contains a different anion/cation. In addition, the order of the rows should match the order you want to see on the plot. Each sample should be a different column. An example of the required data layout exists in the sample data file Schoeller.xlsx, located in the Grapher Samples directory.

Once the data is input, open the Schoeller.grf file, located in the Samples directory. This file uses the sample XLSX file, but is easily changed to your data by completing the steps below:

1. Click on the bottom line/scatter plot (named A) in the Object Manager.
2. Hold down the SHIFT key on the keyboard and click on the top line/scatter plot (named L).
3. In the Property Manager, click on the Plot tab.
4. Click the current value in the Worksheet field and select Browse.
5. Select your data file and click Open.
6. Click X Axis 1 in the Object Manager.
7. Click on the Labels tab in the Property Manager.
8. In the Worksheet field, click on the current value and select your worksheet from the list.
   
9. Choose the appropriate data column for the Label column field.
10. If desired, edit the line/scatter plot names, to match the sample names in your worksheet.

If additional samples are input, additional line/scatter plots can be added by following these steps:

1. Click on the top line/scatter plot (named L) in the Object Manager.
2. In the Property Manager, click on the Plot tab.
3. In the New plot field, click the Create button. A new line/scatter plot is added using the same X column (row number) and the next Y column (sample).
4. Repeat this process until all samples are displayed.
5. Change the line properties by clicking on each new line/scatter plot and changing the line Color on the Line tab in the Property Manager.

Updated July 16, 2019