Scatter charts

Scatter charts show numeric coordinates along the horizontal (X) and vertical (Y) axes. Use a scatter chart when you want to find out how much one variable is affected by another. For example, plot the salary of employees and years of experience.

• First column: Enter values for the X axis.
• First row (Optional): In the first row of each column, enter a category name. Entries in the first row show up as labels in the legend.
• Other columns: Enter Y values. Each column of Y-values shows up as a series of points on the chart.
• Other rows: Each row is a point on the chart.

Tips:

• Add a trendline to find patterns in your data.
• The closer the data points come to making a straight line, the stronger the correlation between the 2 variables.

Customize a scatter chart

1. On your computer, open a spreadsheet in Google Sheets.
2. Double-click the chart you want to change.
3. At the right, click Customize.
4. Choose an option:
   • Chart style: Change how the chart looks.
   • Chart & axis titles: Edit or format title text.
   • Series: Change point colors, axis location, or add error bars, data labels, or trendline.
   • Legend: Change legend position and text.
   • Horizontal axis: Edit or format axis text, or reverse axis order.
   • Vertical axis: Edit or format axis text, set min or max value, or log scale.
   • Gridlines: Add and edit gridlines.
   • Bubble: For bubble charts, change how the bubble looks.

• Add & edit a trendline
• Types of charts & graphs in Google Sheets
• Add & edit a chart or graph