Google sheets have become an extremely convenient tool for users. It provides a lot of functions and features for people to use. One such useful feature is the inbuilt tool for generating scatter plot graphs. Scatter plots are important as they depict the trends and relationships in data when other graphs are not up to the mark.
Scatter plots help you to represent the data when it’s haphazard but still represent a trend. Also, they can be used to convey data point clusters which can be depicted properly neither by bar nor by line charts. Users can further analyze the data trends and demonstrate the connection between data points by using trend lines. To point out which data points are outliers, error bars can be used.
If you are willing to know how to make a scatter plot in Google sheets, you have come to the right place. Scatter plots are one of the various in-built features that Google sheets offer. Follow the steps mentioned below to curate a scatter plot just like you wanted!
Steps to make a scatter plot in Google sheets:
- In Google Sheet, first select the data for which you want to plot a graph of:
- Now navigate to Insert > Chart
- A new side window will appear, select the scatter chart:
- You can also customize the axis, colour of the chart on the customize panel of the pane:
- Your chart will be ready and will show alongside your Sheet data: