Enter your data for Binned Scatterplot

Graph > Binned Scatterplot

Enter the x- and y-variables, define the gradient, and select the gradient type.

Enter the Y-variable and X-variable

In Y-variable, enter a column that you want to explain or predict. In X-variable, enter a corresponding column that might explain or predict changes in the y-variable. Both columns must be numeric and have the same number of rows.

In this worksheet, Debt Ratio is the y-variable and Age is the x-variable. The graph shows the relationship between debt ratio and age.

C1 C2
Age Debt Ratio
45 0.80298
40 0.12188
38 0.08511
... ...

Select what the gradient is defined by

Select how you want to define the color scale of the bins on the binned scatterplot.

Frequency of binned data
Select to define the gradient scale by the number of observations in the bin.

In this example, bins with 180 observations or more are dark red. Bins with 60 observations or fewer are dark blue. Bins with between 60 and 180 observations are lighter shades of blue, red, and gray.

Mean of variable
Select to define the gradient scale by the value of a third variable.

In this example, when the average value of all observations of the third variable is greater than 5, the bin is dark red. When the average value of all observations of the third variable is less than 1, the bin is dark blue. Bins with average values between 1 and 5 are lighter shades of blue, red, and gray.

Select the Gradient type

Select the color scale for the bins.
Diverging
Bins with high values are red, and bins with low values are blue.
Sequential from low to high
Bins with high values are dark blue, and bins with low values are light blue and light gray. You can use this option to highlight bins with more productivity or to maximize revenue.
Sequential from high to low
Bins with low values are dark blue, and bins with high values are light blue and light gray. You can use this option to highlight bins with low defect rates or to minimize cost.

Gradient symmetric around value (optional)

Enter a value to center the gradient scale at a specific value rather than the center of the grouping variable or the frequency of the binned data. For example, a research team selects the gradient to be defined by the mean of the profit of all the products in the bin. The owner enters 0 as the Gradient symmetric around value (optional) so that bins with products that made a positive profit are a different color than those that lost money.
Note

This option is only available when you select Diverging from Gradient type.

By using this site you agree to the use of cookies for analytics and personalized content.  Read our policy