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.