How to Create an X-Y Scatter Plot in Excel?

Excel is powerful data visualization and data management tool which can be used to store, analyze, and create reports on large data. It can be used to visualize and compare data using a graph plot. In excel we can plot different kinds of graphs like line graphs, bar graphs, etc. to visualize or analyze the trend. To draw an X-Y plot, it is recommended to use a scatter plot.

Scatter chart 

It is used to understand the correlation between two data variables. A dot is used to represent the values where each dot represents two values (X-axis value and Y-axis value). This chart can be used to visualize the trend and relation between two values over time. For the purpose of demonstration we will use the below-given dataset,

It has X values and the corresponding Y values.

Drawing X-Y Plot using Excel

Step 1: Select the data 

Step 2: From the Insert tab, select scatter chart with a marker.

Output

Steps to make changes in the graph

Step 1: Click on the chart title 

Step 2: The chart format menu will open. Make desired changes. For example, change the chart title.

Output

You can see that the chart title is changed to X-y plot.