Close this search box.

Table X-mR and Table X Help

The Table X-mR option and the Table X Chart allows you to make multiple X-mR charts or X charts at one time. This page explains how to do this using the data that can be downloaded at this link. This help pages shows the Table X-mR instructions but the Table X chart is done the same way. There are two options with the Table X-mR: to treat the data as single X-mR charts (if they will have different options) or to create multiple X-mR charts with the same options. This page contains the following:

Before running the Table X-mR it is recommended that you review X-mR (Individuals) charts to understand how X-mR charts are developed and the options available.

Data Entry

The data are entered into a worksheet as shown below (using the first part of the data into the example workbook).  The data does not have to start in A1.  It can be anywhere on the spreadsheet.  The data can be in rows or in columns.  With an individuals chart, there is only value of X for a given sample (time period). 

The data entry example above has the data in columns (sample identifier and result are in one row across columns). The sample identifiers are in one column (under “Sample”). There are three charts that will be made from this data. You can have as many charts in the Table X-mR as you want. The data for each individual chart is shown under the headings X1, X2 and X3. This is all the data entry you need if you select the option to “show input for each X-mR chart” (see below). This is the option you will use if your single X-mR charts will have different options.

If all the X-mR charts will have the same options, you will need to add some additional information to the worksheet for the second option. The “Chart Names” are listed in one row (row 9 in this example) above. This the name of the chart that will appear on the worksheet tab must be unique. The first chart is named “MyChart1”. You must have the “Chart Names” information. The information for that chart is under that heading. The “Y Axis Label” and the “X Axis Label” are one row also (rows 10 and 11 in this example). These are optional as well as for the mR Chart (see below; in this example, the mR Chart axis information was not included)

Running the Table X-mR

Note: if you select the first option to show the input form for each X-mR chart, you do not need to have the chart names and optional axes labels entered into the worksheet.

Scroll to Top