Close this search box.

Scatter Diagram Help

A scatter diagram examines the relationship between two variables, X and Y. Quite often you are looking to determine if Y can be controlled by controlling X. This page shows to make a scatter diagram. The data can be downloaded here. This page contains the following:

You can fit the following trend: linear (default), logarithmic, polynomial, power or exponential.

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 but must be in columns.

Creating a New Scatter Diagram

This is all that is needed to make the scatter diagram. If you select OK at this point, the software will generate the scatter diagram using the default options.

4. Once you have entered the information, select OK and the scatter diagram will be generated. An example based on the data above is shown below

Options for the Scatter Diagram

On the input screen for the scatter diagram, there is the button labeled “Show Options”. If you select that button, the input screen will show the options available for the scatter diagram. It is not required to select any of these options. The options are explained below.

Titles, Dates

If you select the “Titles, Dates” option, the input screen below is shown.


If you select the “Labels” option, the input screen below is shown. This option allows you to add labels to the points on the scatter diagram. The labels must be in columns if the X and Y values are in columns (likewise for rows).

Best Fit Equation

If you select the “Best Fit Equation” option, the input screen below is shown.

Updating the Scatter Diagram with New Data

The scatter diagram can be easily updated with new data after it has been added to the spreadsheet. The updating of the scatter diagram with new data are based on the X values entry. Suppose the data you used for the original scatter diagram was for sample numbers 1 to 15. The last X value is in cell B18. You have now added new data: samples 16 and 17 as shown below.

When you update the scatter diagram, SPC for Excel does the following:

Changing the Options for the Scatter Diagram

You can change the current options for the scatter diagram by selecting “Options” on the “Updating/Options” panel on the SPC for Excel Ribbon.

The list of available charts in the workbook will be displayed. Select the chart you want to change options for. The input screen for that chart will be shown and changes can be made. See Changing Chart Options for more information

Scroll to Top