Choosing the right type of chart or graph can be key to convey the most important insights of your data—on sight.
Scatter chart plots the values for two variables as a set of points on a graph.
When we look at the raw data it is hard to find what’s going on, so we will use them to create a scatter chart.
- Select all the cells than contains data
- Click on Insert tab
- Look for Charts group
- Under Chart group, you will find Scatter (X, Y) Chart
- Click the arrow to see the different types of scatter and bubble charts
- You can pause the pointer on the icons to see the preview in your document
- Click on Scatter Chart
- On Clicking, you will see the scatter chart.
- You can quickly edit the chart by clicking the icons available on the right side of the chart
Using Trendlines In Scatter Charts
- Select the Chart
The moment you select the chart, Design and Format tab appears
- Go to Design
- Look for “Add Chart Element”
- Click on the drop down and you will see various types of elements which you can add to chart
- Look for Trendline
- Click on the dropdown of Trend line
Various trend line options are available. You can hover the mouse over it to see preview in the chart
- I will click on Linear option
On Clicking, trend line has appeared in the chart.This Trendline helps us understand the data better, but we can also add more useful information.It represents a linear equation and we can make that equation displayed on the chart, if we wish to.With the chart selected,
- Click on the trend button again
- Go to Design
- Click on “Add Chart element”
- Click on “Trendline”
- Click on “More trendline options”
- The moment you click on ‘More trend line options’, you will see ‘Format trendline” on the right side of your excel.
- Scroll this down to see “Display equation on the chart”
- Click on “Display equation on chart”
- On Clicking, you will see equation is displayed on the chart.
So that was Scatter Plot. Hope you liked it. Don’t forget to comment your take on Scatter Plot.