How to Make Plots in Excel? (with Examples)

Example#1 – Simple Scatter Plot

To create the simple scatter plotScatter PlotScatter plot in excel is a two dimensional type of chart to represent data, it has various names such XY chart or Scatter diagram in excel, in this chart we have two sets of data on X and Y axis who are co-related to each other, this chart is mostly used in co-relation studies and regression studies of data.read more, place the data into two columns, as shown in the screenshot.

The scatter plot is developed, as shown in the below mentioned figure.

  • First, select the data, including the two columns, such as the advertising expenses, the number of items sold, and column headers. In this situation, the range of data is B1:C10. Go to the “Insert” tab, move to a “Scatter” plot, and place the cursor, as shown in the figure. Choose the “Scatter” plot to represent the relationship between the data sets.

In this situation, the range of data is B1:C10.

We can change the format and design of the chart area using the “Design” and “Format” tabs.

Example#2 – Scatter Plot with Smooth Lines and Markers

To create the simple scatter plot with lines and markers, place the data into two columns, as shown in the screenshot.

Step 1: Select the data, including the two columns, such as the advertising expenses, the number of items sold, and their column headers. In this situation, the range of data is B1:C10.

Step 2: Go to the “Insert” tab and choose the scatter plot with markers and lines to represent the relationship between the data sets.

The scatter plot with lines and markers is shown in the below-mentioned figure.

Example#3 – Scatter Plot with Smooth Lines

Place the data into two columns to create a simple scatter plot with smooth lines.

Select the data, including the two columns, such as the advertising expenses, the number of items sold, and column headers. For example, in this situation, the range of data is B1:C10.

Go to the “Insert” tab, move to a scatter plot, and choose the scatter plot with lines representing the relationship between the data sets.

Example#4 – Scatter Plot with Straight Lines and Markers

To create the simple scatter plot with straight lines and markers, place the data into two columns, as shown in the screenshot.

Go to the “Insert” tab, move to a scatter plot, and choose the scatter plot representing the relationship between the data sets.

The scatter plot is developed, as shown in the below-mentioned figure.

Change the chart type to scatter with straight lines, as shown in the figure.

The scatter with straight lines is developed, as shown in the figure below.

Example#5 – Bubble Chart

To create the simple bubble plot, place the data into two columns, as shown in the screenshot.

Go to the “insert” tab,Insert TabIn excel “INSERT” tab plays an important role in analyzing the data. Like all the other tabs in the ribbon INSERT tab offers its own features and tools. Under Insert Tab we have several other groups including tables, illustration, add-ins, charts, Power map, sparklines, filters, etc.read more move to the bubble plot, and choose the bubble plot to represent the relationship between the data sets.

The bubble plot is developed, as shown in the below-mentioned figure.

Change the chart type to a 3-D bubble plot, as shown in the figure.

The 3-D bubble plot is developed, as shown in the figure below.

Applications

Scatter plots have different applications. These are used in:

  • Resolve a problem through data analysisDetermining the correlationDetermining The CorrelationCorrelation is a statistical measure between two variables that is defined as a change in one variable corresponding to a change in the other. It is calculated as (x(i)-mean(x))*(y(i)-mean(y)) / ((x(i)-mean(x))2 * (y(i)-mean(y))2.read more between the independent and dependent variables.It is used as a quality tool in determining the causes of an issue.It tests the autocorrelation before building the control chartsControl ChartsThe control chart analyses how data changes over time in business statistics, allowing users to see how any process changes. Its components are the control line, as well as the upper and lower control lines, which are formed using the data’s average and standard deviation.read more in quality analysis.It helps to show the non-linear pattern.A user can easily identify the minimum and maximum values in the range of data flow.Three relationships between variables: no relation, positive, and negative relationships, are analyzed effectively using the scatter plot. It helps to understand how changes in one factor will affect another factor.

Things to Remember

  • It is hard to create a chart if the data of a variable is presented in a non-numeric format.A small amount of data is useful in performing better data analysis with the scatter plot.It must be taken care of while performing proper data analysis without errors.The user must understand how to utilize and interpret data carefully and properly.We must always add colors and change the chart format to enhance users’ visual appearance.

This article is a guide to Plots in Excel. Here, we learn to make scatter plots using a scatter plot with smooth lines; a scatter plot with straight lines and markers, and a bubble chart with examples and downloadable templates. You may learn more about Excel from the following articles: –

  • Box Plot in ExcelMake 3D Plot in ExcelDot Plots in ExcelMake Chart Templates in ExcelDATEVALUE Excel Function