Plots In Excel

Article byDhanamma Pandula
Edited byAshish Kumar Srivastav
Reviewed byDheeraj Vaidya, CFA, FRM

What Do You Mean By Plots In Excel?

Plots in Excel are defined as graphs that correlate with the data presented in the two columns. Plots are nothing but Excel’s scatter diagram or scatter charts to tally the data sets in two columns. Two-dimensional XY charts show the relationship between the two variables and analyze the data in multiple views. It is easy to select the right scatter plot to perform data analysis.

Key Takeaways

  • Plots in Excel, also known as scatter diagrams or scatter charts, represent the correlation between data presented in two columns. XY charts depict two-variable relationships and support multi-perspective data analysis. Choosing the right scatter plot is straightforward and significantly enhances analysis.
  • It can be challenging to create a chart if the data for a variable is presented in a non-numeric format. To perform better data analysis with scatter plots, a small amount of data is valid.
  • To perform accurate data analysis, avoid errors, and interpret data carefully. Enhance the visual appearance by adding colors and changing the chart format.

How To Make Plots In Excel?

Plots in Excel helps users convert data into plot charts. Let us learn how to create plots in Excel with detailed examples.

You can download this Plots in Excel Template here – Plots in Excel Template

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.

Plots Excel Example 1

–>> If you want to learn Excel and VBA professionally, then ​Excel VBA All in One Courses Bundle​ (35+ hours) is the perfect solution. Whether you’re a beginner or an experienced user, this bundle covers it all – from Basic Excel to Advanced Excel, Macros, Power Query, and VBA.

Follow the steps to create a scatter plot in Excel:

  1. 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.

    Plots Excel Example 1-1

  2. Go to the “Insert” tab, move to a “Scatter” plot, and place the cursor, as shown in the figure.


    Plots Excel Example 1-2

  3. Choose the “Scatter” plot to represent the relationship between the data sets.


    Plots Excel Example 1-3

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

Plots Excel Example 1-4

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.

Plots Excel Example 2

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.

Plots Excel Example 2-1

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

Plots Excel Example 2-2

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

Plots Excel Example 2-3

Example #3 – Scatter Plot With Smooth Lines

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

Plots Excel Example 3

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.

Plots Excel Example 3-1

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

Plots Excel Example 3-2

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

Plots Excel Example 3-3

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.

Example 4

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.

Example 4-1

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

Example 4-2

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

Example 4-3

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

Example 4-4

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

Example 4-5

Example#5 – Bubble Chart

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

Create Bubble Chart Example 5

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.

Create Bubble Chart Example 5-1

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.

Create Bubble Chart Example 5-2

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

Create Bubble Chart Example 5-3

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

Create Bubble Chart Example 5-4

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

Create Bubble Chart Example 5-5

Applications

Scatter plots have different applications. These are used in:

Important Things To Note

  • 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.

Frequently Asked Questions

1. What do you use to create a plot in Excel?

To create a plot in Excel, one must choose the data they want to plot in the chart. Then, click the ‘Insert’ tab, and then click ‘Line,’ and pick an option from the available line chart styles. With the chart selected, click the ‘Chart Design’ tab to do any of the following: Click ‘Add Chart Element’ to modify details like the title, labels, and legend.

2. How do I add labels to a scatter plot in Excel?

To label the points in your scatter graph, follow these steps: 1. Select the plot and click on ‘Chart Elements’. 2. Check ‘Data Labels’ and click ‘More Options’. 3. Go to the ‘Label Options’ tab and select ‘Value From Cells’. 4. Choose the range to extract data labels. 5. Clear the X Value and/or Y Value box to show only names. 6. Set the position of the labels as ‘Above data points.’ After completing these steps, your Excel scatter plot data points will be labeled with names for easy comprehension.

3. How do I create a map plot in Excel?

To create a map chart, select any cell within the data range, then go to the ‘Insert’ tab, click on ‘Charts,’ choose ‘Maps,’ and select ‘Filled Map.’ If the preview looks good, click ‘OK.’ Depending on your data, Excel will insert either a value or a category map.

Recommended Articles

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: –