How to Create Combination Charts for Comparing Data in Excel?

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

Last Updated : 02 Jun, 2022

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,

Dataset

It has X values and the corresponding Y values.

Drawing X-Y Plot using Excel

Step 1: Select the data

Selecting-data

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

Selecting-scatter-chart

Output

Output

Steps to make changes in the graph

Step 1: Click on the chart title

Clicking-chart-title

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

Changes-in-chart

Output

Output

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

How to Create Combination Charts for Comparing Data in Excel?

romy421kumari

Improve

Article Tags :

Similar Reads

How to Create a Scatter Plot In Excel?

A scatter plot in Excel is a powerful visualization tool for identifying trends, relationships, and patterns between two variables. By plotting data points on an Excel XY scatter plot, you can gain insights into correlations and outliers, making it an essential tool for data analysis. Whether youâ€™re

How to Create a Stem-and-Leaf Plot in Excel?

Stem and Leaf plot is a histogram tabulation of data. Stem and leaf plot is better for data visualization and cleanliness of the data in a certified range. The plot helps determine the frequency distribution of the data. In this article, we will learn how to create a stem and leaf plot in excel. Ste

How To Create Dot Plots In Excel?

A Dot plot is a type of chart used in statistics for representing relatively small data sets where the values are uniquely categorized. A dot plot is also known as dot chart or strip chart. A dot plot and a bar graph are similar in the sense that the height of each â€œbarâ€ of dots is equal to the numb

How To Create A Pictograph In Excel?

The Pictograph is the record consisting of pictorial symbols. Generally, in mathematics, it is represented by the help of graphs with pictures or icons representing certain quantities or numbers of people, books, etc. It is also known as pictogram, pictogramme, pictorial chart, picture graph, or sim

How to Create a Forest Plot in Excel?

Forest plots are an excellent way to convey a multitude of information in a single picture. Forest plots have become a recognized and well-understood technique of displaying several estimates concurrently, whether used to demonstrate various outcomes in a single research or the cumulative knowledge

How to Create a Forest Plot in R?

In this article, we will discuss how to create a Forest Plot in the R programming language. A forest plot is also known as a blobbogram. It helps us to visualize estimated results from a certain number of studies together along with the overall results in a single plot. It is extensively used in med

How to Create a Step Chart in Excel

A step chart is used to represent data that changes irregularly between time intervals. Now, Excel doesn't have a feature to create a Step Chart like the one shown below but we can create one by making some changes in our data. What is a Step Chart in ExcelA Step chart is the same as a Line Chart. T

How to plot excel data in R?

Plotting graph in R using an excel file, we need an excel file with two-column in it, the values in the first column will be considered as the points at the x-axis and the values in the second column will be considered as the points at the y-axis. In this article, we will be discussing the approach

How to Create a Bland-Altman Plot in Excel?

Bland-Altman plot is not present by default in excel, but it can be easily built with the help of excel. There is software that provides in-built Bland-Altman plots like MedCalc, Analyse-it, etc. In this article, we will learn how to create a Bland-Altman plot in excel. A Bland-Altman plot is used t

How to Create an Ogive Graph in Excel?

Ogive graph, the name might scare you, but believe me this is very simple to create. The ogive graph is a cumulative frequency graph. The graph is plotted between the fixed intervals vs the frequency added up before. It is a curve plotted for cumulative frequency distribution on a graph. There are t