Setting Scatter Chart Preferences

  To set scatter chart preferences, which determine chart appearance:

  1. In the scatter chart window, select Preferences, and then Chart.

    The Chart Preferences dialog opens.

  2. On the General tab, you can set the following features, described in the sections in parentheses:

  3. Optional: Click the Chart Type tab for more settings:

    • Select whether to draw points, and if selected, to select a symbol, color, and size for them.

    • Select whether to draw a line, and if selected, to select a line type, color and size. The Ordered Fit line type shows where pairwise points would be displayed if they were sorted in ascending order. The Linear Regression line type uses a least-squares technique to show the linear relationship of the points.

    • Select whether to display correlation coefficients for each plot. These are computed using the Spearman rank correlation method.

    • Select whether to display points that have been filtered out (Scatter Charts and Filtered Data).

  4. Optional: Use the Axis tab to select a number format for the chart axes and to indicate whether to round axis values (Customizing Chart Axes and Axis Labels).

  5. Optional: Select Defaults at any time to restore all settings to their original default values.

  6. Optional: To apply the settings to more than one chart, click Apply To (Applying Settings to Multiple Charts) and click OK.

  7. When settings are complete, click OK.