Scatter Chart (XY Chart)
A Scatter Chart, also known as an XY Chart, is used to show the relationship between two numerical values. Each point on the chart represents one record with an X value and a Y value.
Scatter Charts help identify:
- Relationships between variables
- Patterns and trends
- Positive or negative correlation
- Outliers (unusual values)
When to Use a Scatter Chart
- Study relationship between Study Hours and Marks.
- Compare Advertising Cost and Sales.
- Analyze Height and Weight data.
- Compare Experience and Salary.
- Scientific and statistical analysis.
Example Data
The following data shows the relationship between Study Hours and Marks scored by students.
| Study Hours (X-Axis) | Marks (Y-Axis) |
|---|---|
| 2 | 40 |
| 3 | 48 |
| 4 | 55 |
| 5 | 65 |
| 6 | 75 |
| 7 | 82 |
Understanding the Result
In the above example:
- X-Axis represents Study Hours.
- Y-Axis represents Marks.
- Each dot represents one student.
- As study hours increase, marks also increase.
Observation: There is a positive relationship between Study Hours and Marks.
Types of Correlation
| Correlation Type | Description |
|---|---|
| Positive Correlation | When one value increases, the other value also increases. |
| Negative Correlation | When one value increases, the other value decreases. |
| No Correlation | No clear relationship between values. |
Steps to Create a Scatter Chart
- Arrange data in two columns (X Values and Y Values).
- Select the data range.
- Click the Insert tab.
- Go to the Charts group.
- Click Insert Scatter (X, Y) Chart.
- Select Scatter with Markers.
Scatter Chart Components
| Component | Purpose |
|---|---|
| X-Axis | Independent values. |
| Y-Axis | Dependent values. |
| Data Points | Represent individual records. |
| Trendline | Shows overall relationship. |
Advantages of Scatter Charts
- Shows relationships clearly.
- Easy to identify trends.
- Helps detect outliers.
- Useful in research and data analysis.
- Supports trendline analysis.
Limitations of Scatter Charts
- Requires numerical data on both axes.
- Not suitable for text categories.
- Can become cluttered with large datasets.
