Scatter Chart

A scatter plot is a type of chart that displays individual data points on a two-dimensional graph. Each point represents the values of two variables, allowing for the observation of patterns, correlations, or outliers.

Example:

Imagine a scatter plot depicting the relationship between the temperature and ice cream sales at an ice cream stand over a year. Each point on the scatter plot represents a specific day, with the x-axis representing the temperature on that day and the y-axis representing the corresponding ice cream sales. The scatter plot allows for the observation of whether higher temperatures correlate with increased ice cream sales.

Steps:

  • Highlight the range of cells containing your data in Google Sheets. Similar to Excel, for X-axis values, select cells in column A (e.g., A1:A30), and for Y-axis values, select cells in column C (e.g., C1:C30).

  • Click on Plot to create a Scatter Chart.

  • You can customize your chart using options in the Chart Editor. For example, you can title your chart, adjust the axis labels, and more.

Output:

Last updated