Which chart type provides the best visual display of the relationship between two numerical values

When selecting the right type type of visualization for your data, think about your variables (string/categorical and numeric), the volume of data, and the question you are attempting to answer through the visualization. Additionally, think about who will be viewing the data and how you can best optimize the data narrative through design. 

Cleveland and McGill (1985) studied the visual characteristics of data visualization that are the easiest and most difficult for the human eye to perceive. They are, in order of least difficult to most difficult: 

1. position along a common scale

2. position along a non-aligned scale

3. length

4. angle and slope

5. area

6. volume, density, and color saturation

7. color hue 

This means that a visualization consisting of differently sized and colored bubbles is more difficult for the human eye to discern than a bar chart (position along a common scale).

Cleveland, William S., and Robert McGill. 1985, "Graphical perception and graphical methods for analyzing scientific data." Science 299 (4716):828-833. 

For in depth information on all of the figures discussed below, please see:

Zoss, Angela M. "Designing Public Visualizations of Library Data." In Data Visualization: A Guide to Visual Storytelling for Librarians, edited by Lauren Magnuson,. Lanham, MD: Rowman & Littlefield Publishers, Inc., forthcoming. 

Which chart type in Excel provides the best visual display of the relationship between two numeric variables?

Scatter plots are useful for showing precise, data dense visualizations, correlations, and clusters between two numeric variables.

Which chart type provides the best visual display of the relationship between two numeric variables box and whisker chart radar chart combo chart XY scatter chart?

A scatter plot displays values on two numeric variables using points positioned on two axes: one for each variable. Scatter plots are a versatile demonstration of the relationship between the plotted variables—whether that correlation is strong or weak, positive or negative, linear or non-linear.

Which chart displays the relationship between two numeric variables?

A scatterplot is a type of data display that shows the relationship between two numerical variables.

Which chart type is best for visualizing the relationship between two variables?

A scatter plot or scattergram chart will show the relationship between two different variables or reveals distribution trends.