Make Scatter Chart in Excel | MS Excel in Hindi

Scatter Chart | X Y chart

Scatter Chart and Line charts look very similar when Scatter charts are displayed with connecting lines. The difference between Line chart and Scatter chart is the way data is plotted on the horizontal axis. A scatter charts never displays categories on the X-Axis or the Horizontal axis.

In Scatter chart both the Axis represents numeric values. Scatter charts are also called XY Chart. The points are plotted where two data points intersects each other. These data points may or may not be evenly distributed along the Axis.

Scatter charts are mainly used when we want to display or compare numeric values. These Chart shows the relationship between the two numeric values. There are seven types of Scatter chart in the scatter charts drop down out of which two charts are Bubble charts. The five options for scatter charts are : Scatter charts, Scatter with Smooth lines and Markers, Scatter with Smooth Lines, Scatter with Straight Lines and markers, Scatter with Straight Lines.

Tip: To change the spacing for X-axis and Y-Axis double click on one of the numbers to open the Edit Scale box.  You can change the Spacing here from the variety of options available.

Steps to create Scatter Charts in Excel:

Step 1: Select the range of cells or Highlight the cells. Here A1: D11 is selected.

Scatter Chart - data example

Step 2: Go to the Insert tab > Chart group > Click on Scatter Chart or XY Chart.

Scatter Chart - Insert tab

Step 3: From the drop down menu, Select Scatter with Straight Lines with markers.

Scatter chart - Straight Lines with markers

Step 4: The Scatter chart with straight lines with Markers or XY Chart will be displayed in the worksheet.

Scatter chart

X Y Chart

To know the relationship between the two variables i.e. X variable(Person Salary) and Y variable(person expenses) we will use the Scatter chart.

Steps to Include Scatter Chart without Straight line are:

Step 1: Select the range of cells or Highlight the cells.

XY Chart

Step 2: Go to the Insert tab > Chart group > Click on Scatter Chart or XY Chart.

Scatter chart - XY Chart

Step 3: The Scatter chart or XY Chart will be displayed in the worksheet.

XY Chart example

Note: Add a trendline to clearly see the relationship between the two variables.

The Scatter charts will help you to know whether there is positive or negative correlation between the two variables. If the data points move in the upward direction i.e. from left to right it goes up then we say there is positive correlation. And if the data points move in the downward direction i.e. from right to left it goes down then we say there is negative correlation.

After the Scatter Charts is inserted, you can format and design your Chart like other charts as well. Change the chart color, Change the Chart style, Switch between Row/Column, remove or add chart element, Change chart type and many more.

Hope you like our tutorial for more cool and amazing trick of excel Like our Excel Superstar Facebook Page and subscribe to our Excel Superstar YouTube channel. Excel Superstar is the leading online training company, which provides Online Excel Course in Hindi. Connect with us and become an Excel Superstar.