XY Scatter Chart in Excel – Usage, Types, Inserting Scatter Chart

XY Scatter chart is a unique chart type that is used in special cases. Its usage is quite easy to understand. In this blog, we are going to understand the base of XY Scatter charts.

What are XY Scatter Charts in Excel

As the name “XY Scatter” suggests to you, there are two axes i.e X-Y Axis. The coordinates are scattered between these two axes. In this chart, there is no category axis. Instead, both the horizontal and vertical axis represents the (x,y) coordinates for each of the data points that plot on the chart.

Consequently, this chart helps us visualize the relationship between two attributes of an entity. For example height-weight relationship for a person, distance-time relationship for a traveling car.

Types of XY Scatter Charts

There are seven types of XY Scatter charts. The functionality of all of them is similar except for their appearance.

types of XY Scatter charts

For instance, seven chart types are as follows:-

  • 1st – Scatter Chart in Excel
  • 2nd – Scatter with Smooth Lines and Markers
  • 3rd – Scatter with Smooth Lines
  • 4th – Scatter with Straight Lines and Markers
  • 5th – Scatter with Straight Lines
  • 6th – Bubble
  • 7th – 3D Bubble
infographics XY Scatter Charts in Excel

Inserting Scatter Chart

Starting from the first chart type of XY Scatter Charts i.e Scatter charts. Let us say we have the following information about the travel journey of a bus on a trip.

inserting Scatter chart in excel raw data

Following are the steps to insert a Scatter chart:-

  • Select the range of source data A2:B7
  • Click on Insert Tab on the ribbon.
  • Hit on the Button for XY Scatter charts

Click on this button. As a result, excel would insert a Scatter Chart in the current worksheet containing source data.

scatter chart in excel insertion result

Plotting Coordinates of Scatter Charts

As we know the source data contains the distance covered with time. So there are two coordinated which would plot the points on the chart.

reading scatter charts in excel

In the above chart:-

  • The X axis or Horizontal Axis has the Time.
  • The Y axis / Vertical Axis has the distance.
  • The Six Coordinates are plotted between the two axes.
  • We can easily visualize the coordinates for each data point through the axis,

Adding and Formatting Data Labels

Consequently, we can add the data labels on the chart to see the coordinates for each point.

To add the Data Labels on the chart:-

  • Click on the chart
  • On the top right corner of chart, a + icon would appear. Click on it.
  • Mark the Data Labels from the menu and click on More Options
adding data labels on a chart in excel

This opens the Format Data Labels Pane on the right of the excel window.

From there mark the X and Y coordinates to be displayed via the Data Labels.

formatting the data labels of a chart in excel

Mark the X Value and Y Value coordinate. This is how the chart looks now.

adding coordinates on the scatter chart in excel

Remember that the coordinates would be in the format (x,y) i.e (Distance, Time)

Adding Chart and Axis Titles

We haven’t added the proper chart and axis title yet. to add them simply:-

  • Select the chart
  • Click on the + icon.
  • Mark the Chart title and Axis title from there

As a result, default chart and axis titles add to the charr. To change them:-

  • Double click on the default chart title
  • Type the new chart title
  • You will see that while typing, the new title is typed in the formula bar
  • Hit enter and the title in the formula bar will update the actual chart title
  • Similarly, you can change the axis titles.
adding chart and axis title on the charrt in excel result

To further extend your knowledge about Adding/Deleting Chart elements, click here.

However, you can Formar Your Chart to make it look even better.

This brings us to the end of the blog.

Thank you for reading 😎

Leave a Comment