Excel scatter Chart

This post will explain that how to create a basic scatter chart in your current worksheet based on the specified data points in Excel.  You will learn that how to create a scatter plot or XY scatter chart in Excel. You can use the scatter chart to show the relationship between set of values.

Create Scatter Chart

If you want to create a Scatter chart in your current worksheet, just need to the do following steps:

1# Select the data range that you want to use for the scatter chart, such as: B1:D4.

excel scatter chart0

2# go to Insert Tab, Click Insert Scatter (X,Y) or Bubble Chart button under Charts group. (You can click the arrow to see the different types of scatter and bubble charts available and pause the pointer on the icons to see a preview in your worksheet)

excel scatter chart1

3# click any one Scatter or Bubble from the drop down list.

excel scatter chart2

4# you will see that one Excel Scatter Chart has been generated as below:

excel scatter chart3